Trigger automation using action button!!

[Aditya_K1999]

I want to trigger an automation that I have created, basis an action button. Please assist on how to do it.

[Suvrutt_Gurjar · Accepted solution]

Please read the part "Send an email from an action button" in the help article below. The example describes sending an email. But you can invoke  other automations also from an action button. Basically the action button changes a column value and that in turn acts as a data change event condition. 

Example automations - AppSheet Help

[Suvrutt_Gurjar · Accepted solution]

Please read the part "Send an email from an action button" in the help article below. The example describes sending an email. But you can invoke  other automations also from an action button. Basically the action button changes a column value and that in turn acts as a data change event condition. 

Example automations - AppSheet Help

[mstan08 · Accepted solution]

The easiest way to do this is to have a "trigger" column on your data table, then use the action to modify that trigger field. 

The automation should look for a data change on that specific field

This will look for any change to that specific column:

[_THISROW_BEFORE].[triggerColumn]<>[_THISROW_AFTER].[triggerColumn]

This will look for a specific change to your column:

AND(

[_THISROW_BEFORE].[triggerColumn]<>[_THISROW_AFTER].[triggerColumn],

[_THISROW_BEFORE].[triggerColumn]="your desired trigger value (from the action)"

then have as the last step in the automation to clear the value in the trigger column. 

I hope this helps!

[Aditya_K1999]

Thank you guys got it!