PROBLEM: I’m designing a workflow where I need to 1) send a notification, 2) send a second notification if there’s no response after three business days, 3) send a third notification after another three days, and 4) “terminate” if still no response after the 3 notifications/9 business days.
QUESTION: How can I efficiently implement - and use - a “date table” that will account for “weekends” and “holidays”?
Solved
Efficient "date table" for Nintex Workflow?
+5- Nintex Partner
Best answer by brent_read
Hi
Normally when I implement something along these lines I would use the date table for holidays and use a format date to string action with a regex to check the day of the week, Using the day of the week you can then set the number of hours to wait to either 72 or 120 (3 or 5 days). Once you have that, you can use an add time to date action and query the holiday date table for any records with a date that falls between the current date and the date from the add time to date action and add 24hrs for each of those. Then use a pause for duration with that timeframe. Put all of that in a loop with how many times you want to send reminders and you should be good. You may need to add some logic for 2 day holidays but the above is the basic methodology so not exactly a simple process to implement (usually this is easier with a 24 hour check).
- Nintex Employee
- Answer
Hi
Normally when I implement something along these lines I would use the date table for holidays and use a format date to string action with a regex to check the day of the week, Using the day of the week you can then set the number of hours to wait to either 72 or 120 (3 or 5 days). Once you have that, you can use an add time to date action and query the holiday date table for any records with a date that falls between the current date and the date from the add time to date action and add 24hrs for each of those. Then use a pause for duration with that timeframe. Put all of that in a loop with how many times you want to send reminders and you should be good. You may need to add some logic for 2 day holidays but the above is the basic methodology so not exactly a simple process to implement (usually this is easier with a 24 hour check).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.