Task: to send Email
Event: event trigger is daily 9.37pm and filter condition is [next service date ] - today () = 10
the bot tests that Event condition is True
but Email is not being sent automatically.
when I press Run, the email will be sent.
Have you checked the Bot Monitor to see if any errors are recorded there?
I see your in IST timezone running the Bot at 9:37pm. I wonder if there might be some DateTime mis-matches between AppSheet servers and the row data such that the result of “= 10” is not achieved?
A suggestion…instead of “= 10” I would recommend a range such as “< 10”. That way if any Date adjustments are made they will be picked up automatically OR if an error occurs, you find out next day, fix and want to re-run ASAP, you can re-trigger the Bot and it will still pick-up those skipped from the day before.
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |