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

[FerdyanH]

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!

[Aurelien]

Hi @FerdyanH 

Please post in Q&A for future questions. Tips & Tricks are for sharing tips with the Community.

About your question, it may work. You may want to try that, which seems more sure to me:

[Column_name] <> "Word_A"

[FerdyanH]

Thank you @Aurelien,
I’ve tried it, but the automation still doesn't work.
It might be an issue with my Apps Script code, or possibly with the triggers I set up in Apps Script. I've attached the screenshot below for reference :

 

[Aurelien · 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?

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