markwheeler.com - various shenanigans.

DAX: Add Business Days to Date

November 9, 2023 mmwheeler

DAX calculated column code to add business days or network days to a date. VAR __Date = IF(Table1[StartDate] <> BLANK(), Table1[StartDate], date(2000, 1, 1)) // Days to Add; in my use case, the # of days was dependent on a category value. You can just set this a specific number […]

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

Power BI: Plan vs Actual Line Charts

April 29, 2021 (August 30, 2021) mmwheeler

Request was to show a Running Total of Job Vacancies and Filled Vacancies by Target Date. First, I created a Calendar table: Calendar = CALENDAR(DATE(2021,1,1),DATE(2021,12,31))Second, I had to create a Running Total of Job Vacancies from Jan 1st thru the Target Date. CountTotalRunning = CALCULATE( COUNTA(‘Vacancies'[ID]), FILTER( ALLSELECTED(‘Vacancies’), ‘Vacancies'[Need By Date] <=MAX(‘Calendar'[Date]) )) […]

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

Cross County Trail for MapMyRide

June 1, 2020 (February 22, 2021) mmwheeler

Create Routes or Search for a route from millions at MapMyRide CCT Route in GPX Format (zipped)

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

markwheeler.comvarious shenanigans.