I have a table that has a list of notifications I want to send via SMS and through the app. There is a column that specifies the date [Alert Date] and one that specifies the time [Alet Time] that each one needs to be sent. The entries into that table are created by a BOT at 6am UTC every day, so it has all of the notifications I want to send for the day.
I then created another bot to actually send the notifications. I have an event that triggers on when a new row is added to that table. Its process that will send the alert, send the SMS and then delete the corresponding row. That works.
I want to update that process so that each one is only sent at the time specified in the table. I tried adding a “Wait for a condition” where [Alert Time] = TIMENOW() but it doesn’t seem to work. Am I going about doing this in the right way?
Thanks in advance!