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