Reminders based on user set time

[j_witty]

Hello!!

I'm looking to build a feature for one of my applications which allows for the user to set the they would like to receive a reminder.  Currently I have a bot which triggers based on a value change (time they would like the reminder), from there I'm storing a duration value between reminder time and now() to use in a wait step.  I've found the wait step in bots to be very unreliable.  Sometimes this feature works perfectly and others the wait holds for a duration longer than I've told it to.  Wondering if anyone has any advice around this or if I should just scratch this feature entirely because its not feasible.

[Suvrutt_Gurjar]

You could try the following.

You could have 4 hourly scheduled bots , firing at 15, 30, 45, 00 minutes. However this will mean 96bots on daily basis. Of course after office hours there may be seldom reminders so the bots may not return any records.

Point to note will be the scheduled reminder bots also may not fire at the exact instance and there could be some delays.

The filter condition for these bots can be something like

AND( DATE([Reminder DateTime])=TODAY(), HOUR(TIME([Reminder DateTime]) -"00:00:00")=HOUR(TIME(NOW())-"00:00:00") , MINUTE([Reminder DateTime])-"00:15:00") >45) for bot having reminder times for appointments between 0-15 minutes.

You could similarly set conditions for other three bots.  The above expression is just as a suggestion not tested and may need minor adjustments for syntax as well as for edge cases such as change of the date etc. Please test well for all edge cases.