I have a list of meetings that are scheduled normally a week in advance. The date/time of the meeting is set on a table along with other details like the guest’s email addresses.
I want to be able to send them a quick reminder 30 minutes before the email.
So far the way I have done it is with a recurring event that runs weekly (on Monday), scans the table and then schedules an email that would be sent 30 minutes before the meeting. All of this is done in advance.
Now there’s an added capability where users can reschedule the meeting - eg the date will change. The problem is - the email is already scheduled to be sent at the original time, and then everyone is getting confused.
What is a good way to do this? I can run a recurring event every day, but reschedule could happen within the same day, which means the same problem. If it was a recurring event, ideally would have liked to run it every minute or even 10 minutes, but also - there is no way to programmatically cancel a scheduled process, as far as I know, so the original email would be sent anyway…