How to prevent AppSheet Automation from triggering based on specific form input value?

 

Hi everyone,

I'm currently facing an issue integrating Apps Script with AppSheet using the Automation feature.

Here's what I'm trying to do:
I want to prevent the automation from running if a specific value is entered in a form column. For example, if the value "Word_A" is entered in [column_name], then the automation should not be triggered.

I tried using the following condition in the Event step condition:

NOT([Column_name] = "Word_A")

Is this the correct way to write the condition? Or is there a better approach to stop the automation based on a specific column value?

Any help would be greatly appreciated. Thanks in advance!

Solved Solved
0 3 132
1 ACCEPTED SOLUTION

The screenshot provided looks at the trigger on Apps Script side.

Your question was on AppSheet side, right?

Did you call your script this way, for example?

Aurelien_0-1745408376797.png

For reference: Call Apps Script from an automation - AppSheet Help

 

View solution in original post

3 REPLIES 3
Top Labels in this Space