Feb 28, 2023 11:25 AM
Hi,
I have an automation that triggers every day at a specific time.
I want to end the automation after a number of days.
How can I do that?
Thanks,
Jacqueline
Solved! Go to Solution.
Mar 01, 2023 04:35 AM
i think i need it to start sending the emails. so when a record is created start sending emails.
but not sure since i added these two conditions at different times.
Actually the start date condition becomes redundant after day 1.
Mar 01, 2023 10:32 AM
as long as the end date is set when the record is created, it should start sending them straight away.
Mar 01, 2023 04:47 PM
Definitely raise this as a feature request with Airtable in product ideas. Time limited Automations would definitely have their uses. It’s worth noting that (at least if I recall correctly) an automation that triggers failed conditional logic will still consume an automation credit.
Further to a time/turn based automation configuration setting, I think that perhaps it would be cool if we could disabled enable automations via an automation script. 😁
Mar 02, 2023 12:40 AM
yes, good idea.
Just as an aside, if I was trying to do this myself, I would use google apps script for more control over things.
Mar 02, 2023 06:53 AM
Hi Steve, the end date is not equal to when the record is created. The start date is equal to when the record is created. End date happens after a number of days from the start date. I think you are right though that as long as the end date is after today it will send out the email.
Mar 02, 2023 07:14 AM
I do not have coding skills to use google apps script.😅
Hey Steve, I received an e-mail that the automation failed 1 time. Could it be because the entry in the database came from a user with a different timezone than mine? Could it be because the automation works only in timezones in which they are created? Because when I checked what could have gone wrong - every step of the automation was successful - see screenshot.
Mar 02, 2023 07:15 AM
Agreed - it is strange that there is no end date for automations.
Mar 02, 2023 02:02 PM - edited Mar 02, 2023 02:40 PM
Yes, strange that every step seems to have completed. I don't think being in different time zones makes a difference, the end date is either in the future or it's not.
Mar 03, 2023 05:45 AM
I think the problem was that i am on the free plan and cannot send email through airtable. I changed it now to gmail. Should work with gmail.