Hello to everyone,
In my app i would set a BOT that send an email when a training course related to an employee expired.
This is the table where i would like to apply this automation–> Send an email when [SCADENZA] > NOW()
Tks guys!
So what you’re going to have to do i build a bot set to run daily at a given time. Then the trigger will be [SCADENZA]=TODAY() if you want those expiring today. Or use a trigger of [SCADENZA]=TODAY()-1 for those which expired yesterday
1 Like
Thanks for your answer. Yes, it could be a solution but scheduled event is allowed only if the app is deployed.. 
There is another option to make this bot?
Ok in that case make it so the bot triggers on a change in the App. But you’re going ot have to trigger manually it at least once per day
1 Like
if you create an apps script, what is automatically triggered every day, it can modify a cell in a table, and the bot can trigger with that modified cell. so you can set the script to run at 6 am every day for example, write the actual date in that cell, and the bot sees the new value, and triggers itself. i think that should work