Skip to content
Various and Sundry
Various and Sundry

Main Navigation

  • About Me
  • Projects
    • Arduino
    • Music
    • Pinball
    • Raspberry PI
    • Sharepoint
  • Guitar Tabs
  • YouTube
  • Contact Me

Category: Software

Calculate Business Hours in Nintex Form

December 7, 2021 mmwheeler
Calculate Business Hours in Nintex Form

Had a request to create a deadline due date utilizing business hours. Here’s the script. I’m still using the moment.js library for other due date calculations. I’ve also included code here to update the HH:MM blocks of the Nintex Date/Time field.

Computer, Sharepoint, SoftwareNintex Forms

Calculating Business Days for Nintex Form

August 30, 2021 mmwheeler

Had a request to calculate several deadline or due dates from one specific date to autopopulate fields on a Nintex form. This also had to calculate business days only excluding holidays and weekends. I am using the moment.js library and moment-business-days plugin. Upload those .js files to your site assets […]

Sharepoint, SoftwareNintex, Sharepoint

Nintex Form: Get Attachment Link(s) from Secondary List

December 19, 2020 mmwheeler
Nintex Form: Get Attachment Link(s) from Secondary List

Use Case: Hiring Application form that needed to pull Resume attachment from Candidates list. I first setup a calculated column that retrieves the ID from a Candidate Lookup List column. I set a Javascript variable to ‘cID’. parseLookup(Candidate, False) I then created a hidden Single Line Text box with a […]

Computer, Sharepoint, SoftwareNintex

Nintex Form Tricks, Part 2: Set List Lookup defaults to all checked.

July 15, 2019 mmwheeler
Nintex Form Tricks, Part 2: Set List Lookup defaults to all checked.

In the previous post, I had to populate a list lookup control that was filtered by cascading drop-downs. The second task was to default all the training classes as selected. One option is to add a user-selectable Yes/No button to select all the tasks. In my form, the data is […]

Computer, Sharepoint, SoftwareNintex Forms

Nintex Form Tricks, Part 1: Filter List Lookup on Multiple Columns

July 15, 2019 mmwheeler
Nintex Form Tricks, Part 1: Filter List Lookup on Multiple Columns

I had a request to build a form where a manager could assign multiple training classes based on a job-specific need. With multiple cascading drop-down options I had to filter a list lookup. The first task was to create a calculated column in my master SharePoint list. This combined the […]

Computer, Sharepoint, SoftwareNintex Forms

Filtering and Limiting Date Pickers on Nintex Forms

March 25, 2019 mmwheeler
Filtering and Limiting Date Pickers on Nintex Forms

Had a project to create a service scheduling list. Certain services are only available during specific hours and specific days. The trick was to filter the date picker in relation to the service selected via Nintex javascript. All of the code below goes into the Custom Javascript section of your […]

Computer, Sharepoint, SoftwareDate Picker

SharePoint 2016 Copy Shortcut Context Menu

December 8, 2018 mmwheeler

After an upgrade from SP2013 to SP2016, the ability to right-click on a document and copying a shortcut was removed. This is because the IE right-click menu has been replaced by a context sensitive menu that does not include an option for copying a shortcut to the document. The following […]

Computer, Sharepoint, Software

Party Mode mod for Volumio

April 29, 2017 mmwheeler
Party Mode mod for Volumio

Volumio is a headless audio player for the Raspberry Pi. I am using it as a jukebox with the 7′ LCD display. I revised some of the code to work the way I wanted as a “party mode.” 1. From the browse window, the default event for clicking on a […]

Raspberry PI, SoftwareJukebox, Volumio

Access 2013 Crosstab Query with Dynamic Column Headers

March 21, 2017 mmwheeler
Access 2013 Crosstab Query with Dynamic Column Headers

In my scenario, I have a SharePoint 2013 list with Task Name, Assignee, Task Start and Task End. I needed to query the list and parse the data into a pivot table with all dates between the task dates as the column headers. The following steps were pieced together from […]

Computer, Sharepoint, SoftwareAccess 2013, Crosstab Query, Sharepoint 2013

Filtering InfoPath drop-down list on previous, future selections

February 25, 2016 mmwheeler
Filtering InfoPath drop-down list on previous, future selections

Another requirement for my teleconference reservation form was to only allow one unique user to be assigned to a number. I had to figure a way to filter or exclude previously selected users from other drop-down box selections. My user drop-down is populated via the Attendees people picker field from […]

Sharepoint, SoftwareInfoPath, Sharepoint 2010

Posts navigation

  • 1
  • 2
  • 3
  • …
  • 6
  • ❯

Recent Posts

  • Magic Mirror: Add Icons as Carousel Pagination
  • DAX: Add Business Days to Date
  • Calculate Business Hours in Nintex Form
  • Calculating Business Days for Nintex Form
  • Power BI: Plan vs Actual Line Charts

Recent Comments

No comments to show.

Archives

  • July 2024
  • November 2023
  • December 2021
  • August 2021
  • April 2021
  • December 2020
  • June 2020
  • July 2019
  • March 2019
  • December 2018
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • April 2017
  • March 2017
  • February 2017
  • October 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • January 2015
  • November 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • November 2013
  • October 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • January 2013
  • October 2012
  • September 2012
  • July 2012
  • June 2012
  • April 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • July 2011
  • June 2011
  • April 2011
  • February 2011
  • January 2011
  • December 2010
  • October 2010

Categories

  • Arduino
  • Computer
  • Food
  • Hardware
  • Life
  • Music
  • Music
  • Pinball
  • Power BI
  • Projects
  • Raspberry PI
  • Sharepoint
  • Software
  • Sports
  • Uncategorized
Copyright ©2026 Various and Sundry : . Theme: Simple Dark by IndoCreativeMedia.