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 |
---|---|
33 | |
31 | |
30 | |
19 | |
18 |