Ending an automation

[jackline]

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

[Karlstens]

An Automation typically ends in moments, it shouldn’t be able to run for days.

[jackline]

Hey Karlstens,

Thanks for your feedback. May be I didn’t explain well the situation. So let me try again.

I have an automation, trigger type is ‘at a scheduled time’ that triggers an email everyday at a specific time. 

Here’s a screenshot.

I think that if I do nothing else this automation will continue forever.

So how do I stop it. I want to stop it after a number of days, say 20 days.

Thanks

[Steve_Haysom]

End dates would be a useful feature!

Perhaps you could let the automation run but add a conditional rule so that it will only execute before a a set date.

 

[jackline]

Hey Steve, adding a conditional rule might work. This is what I did.

Added a new column in the airtable database with a formula for the date i want the trigger to end - end date.

then added a new condition for the end date in the automation (as shown in the screenshot)

I’m not sure if the automation will work as I want it to work because I am having some problems understanding how the conditioning will work. 

So basically i want to trigger an email over the period between the start and end date.

Jacqueline

[Steve_Haysom]

Hi jackline

It looks like the automation would not run if today was between start date 2 and end date. Should the first condition be start date 2 is on or before today?

Is this part of the scheduled run, otherwise it will only run once.

[jackline]

Hey Steve,

I’m having some issues figuring how the conditions will work together.

But the automation is set up as triggered at schedule time - check the screenshot.

So my reasoning is if the answer to condition 1 is yes - start date is today - email will be triggered and it will continue triggering the email until the end date is on or after today.

example, start day is 01/03/2023 - end date is 08/03/2023 - today is 01/03/023

start date is today - then email is triggered. then it will continue to trigger email until end date 08/03/23 is on or after 01/03/23 - in this case the answer is yes - so email continues to be send out.

I’m not sure if my reasoning is correct.

Jacqueline

[Steve_Haysom]

what about records which have a start date and end date in the future? Then the automation will run before the start date, as the end date is after today.

If this situation might occur, then you want to end up with the logic being Today is between start date and end date, ie where start date 2 is on or before today AND end date is on or after today.

[jackline]

Thats a very good point which I haven’t thought of. 

But start date is a formula and is the date when the record is created so it cannot be in the future.

[Steve_Haysom]

ah ok, in that case I don't think you need the start date at all in the conditions, just the end date?