Send SMS and app notifications at a specific time specified in a column

[Sheldon_Lee-Wen]

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!