Hi - Is it possible to trigger and action/workflow, specifically a text message, on a specific date? I have a “Reminder” date in one of my tables that I would like to use to send a text message to the user who set up the original to-do task. I’ve searched through the AppSheet support and community, but can’t find a thread that addresses this.
Thanks in advance.
Phil
Yes you can do that with a scheduled report. Please check this article…
@Aleksi thank you for your response. While I understand the workflow and scheduled report concepts, I am having trouble with the element that will trigger the text. What I am envisioning (and I don’t know if it is possible) is - a user will create a “to do” and will choose a reminder date/time. On this reminder date/time (which may be a week or two down the road), a column formula, either in the Google Sheet or in AppSheet will have logic that says "if “NOW()” is greater than or equal to the reminder date/time, then return “YES”. Once this column says “YES”, it will trigger the text message with the contents of the “to do” to be sent. It doesn’t need to trigger at a specific time (although it would be nice if it could trigger on the reminder time), but I would need it to trigger on the date. I appreciate any advice you have.
You can achieve this by creating a Report that is invoked every day (or every weekday).
The Report would scan the “ToDo” table looking for any record having a matching “to do” date.
The Report would create an SMS for each matching record.
Can we check both data & time at once (Trigger at the exact DateTime column found in table)
Nope.
To expand on what Steve correctly said, you cannot trigger at the exact date and time specified in a field of a table. Reports are triggered at the most once a day at the time you specify when you configure the Report.
You could achieve an approximation of triggering at the DateTime found in the table by doing the following:
Someone else in the community may have a better suggestion.
Thanks for this suggestion Phil! Is there a better way of doing it 2 years later (almost)?
Nope.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |