I have a workflow that:
- every one hour - eg. 10:00
- reads google calendar events between 11:00 and 12:00
- iterates through the events it finds
- reads the phone number in the summary of each event
- sends an sms reminder for each event.
I need a way to check if an sms was sent to the same phone number during the previous hour check, and not send an sms again to the same phone number, but send an sms to the rest of the numbers.
For example:
- The workflow runs at 10:00 and finds phoneNumber1 at 11:30 and phoneNumber2 at 11:45 and sends an sms to both of them.
- The workflow runs again at 11:00 and finds phoneNumber1 at 12:15 and phoneNumber3 at 12:30.
It should see that it already send an sms to phoneNumber1 during the previous check and send an sms only to phoneNumber3.
How can I do this?
- every one hour - eg. 10:00
- reads google calendar events between 11:00 and 12:00
- iterates through the events it finds
- reads the phone number in the summary of each event
- sends an sms reminder for each event.
I need a way to check if an sms was sent to the same phone number during the previous hour check, and not send an sms again to the same phone number, but send an sms to the rest of the numbers.
For example:
- The workflow runs at 10:00 and finds phoneNumber1 at 11:30 and phoneNumber2 at 11:45 and sends an sms to both of them.
- The workflow runs again at 11:00 and finds phoneNumber1 at 12:15 and phoneNumber3 at 12:30.
It should see that it already send an sms to phoneNumber1 during the previous check and send an sms only to phoneNumber3.
How can I do this?