markwheeler.com – various shenanigans.

Magic Mirror: Add Icons as Carousel Pagination

July 14, 2024 (July 14, 2024) mmwheeler

I am using MMM-Carousel to rotate through various slides in my Magic Mirror implementation. I have updated some of the code in the MMM-Carousel.js The relevant code added: // Line 75 // Line 538 // Line 587 This line replaces the display of the radio buttons with the specified icons […]

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

markwheeler.comvarious shenanigans.