Automation Testing

Coop22

I am currently working through some automations and some different ideas on how to get them to work the way I want. However, the particular automation that I am working through (as far as I can tell) only works when it is run at a particular time (hourly, daily, when a date is reached, etc..). Is there a way to test these automations when I am ready to test them, rather than waiting for the automation to run on the hour? Testing the automation to run at 9:00, finding out that it isn't set up correctly, and then having to wait for 10:00 is a bit annoying. For reference, I am alerting people in contact columns when rows they are are on change, and it is essentially a bulk upload, so receiving an email for each row isn't an option, so I can't use "Run when Triggered".😥

Andrée Starå

Hi @Coop22

I hope you're well and safe!

You could add a so-called helper column (checkbox) and have that trigger the automation manually until you're ready.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Coop22

I hope you're well and safe!

You could add a so-called helper column (checkbox) and have that trigger the automation manually until you're ready.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Coop22

@Andrée Starå I need the email to send all changes in one email. The only way a checkbox would work is if I wanted it to send each row individually right? Or do you know of a way around this?

Andrée Starå

@Coop22

You could either link one master checkbox to the others or use a sheet summary field and link that to all the other checkboxes.

Make sense?