how to trigger notification considering users properties and business calendar

[silviocrive]

Hi All.

For SPM, I need to trigger notification based on:

1. properties of users (department, location, state ...)

2. state of time card vs time sheet

3. business calendar

For example, a montly notification based on point 1. and 2. need to start every 24th of month if it is working day, else the notification need to start the first working day before the 24th.

Similar logic for weekly notifications: based on point 1. and 2. a notification type need to start every friday (another notification type on monday) if it is working day,  else the notifications need to start the first working day before.

So far I'm using flows firing specific events. I'm able to manage with flexibility point 1. and 2. but I'm not able to manage the business calendar.

Any suggestions ? I'm using Zurich, maybe this requirement can be managed by the additional capabilities in Australia ?

Best Regards, Silvio

[Ankur Bawiskar]

@silviocrive 

My thoughts

-> Use a daily Scheduled Script Execution in Zurich with GlideSchedule to compute the effective business day (previous working day before 24th/Friday/Monday), then trigger events for eligible users/timecards

-> Using Flow will be complex and may be you can re-design once you upgrade to Australia

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏