Sharepoint – markwheeler.com

Calculate Business Hours in Nintex Form

December 7, 2021 (December 8, 2021) mmwheeler

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.

Calculating Business Days for Nintex Form

August 30, 2021 (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 […]

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

December 19, 2020 mmwheeler

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 […]

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

July 15, 2019 mmwheeler

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 […]

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

July 15, 2019 mmwheeler

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 […]

Filtering and Limiting Date Pickers on Nintex Forms

March 25, 2019 mmwheeler

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 […]

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 […]

Access 2013 Crosstab Query with Dynamic Column Headers

March 21, 2017 mmwheeler

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 […]

InfoPath – Delete Item via UpdateListItems Web Service

March 4, 2016 mmwheeler

I have been having problems sending a delete request via the lists.asmx web service in SharePoint. My Delete XML packet looks like this: Using the steps found here (http://jaliyaudagedara.blogspot.com/2011/03/submitting-data-to-sharepoint-2010-list.html) I setup a Delete List Item data connection. When trying to delete an item from a list (not document library) I […]

Filtering InfoPath drop-down list on previous, future selections

February 25, 2016 mmwheeler

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 […]