Automation bot getting false triggers

[Rafael_ANEIC-PY]

Hello friends, i’m getting started with automation so i made a simple bot that sends a document via mail when an specific action is used in the app, the bot is triggered when there’s a change made in a specific column using [_THISROW_BEFORE] and [_THISROW_AFTER] but the bot is getting triggered when other actions are done as well, and no other actions change the trigger column for that bot.

The column that triggers the bot is “Imprimircorto”.

Here’s the bot configuration:

Also here’s the configuration for the only action that should trigger the event:

And here’s the configuration for another action that triggers it for some reason:

Any advice is welcome, im wasting a lot on ink printing those duplicates

[Steve]

Recategorized this topic as #appsheet-automation.

[Dan_Bahir]

There is a known issue in the expression evaluation when evaluating empty columns if the Imprimircorto column is empty [Imprimircorto] <> [Imprimircorto] might evaluate to true.

In order to protect from that its suggested that you use ISNOTBLANK(), ISNOTBLANK() | AppSheet Help Center

[Rafael_ANEIC-PY]

Thanks @Dan_Bahir, added a ISNOTBLANK() check to the bot condition:

AND([_THISROW_BEFORE].[Imprimircorto]<>[_THISROW_AFTER].[Imprimircorto],ISNOTBLANK([Imprimircorto]))

I’ll test that to see how it works out.

[Steve]

See also:
https://community.appsheet.com/search?q=@steve%20quirk

[Rafael_ANEIC-PY]

Thanks Steve, those posts explain really well that quirk, adding the ISNOTBLANK() seems to be the easiest solution for the issue.

[eddie61]

@Steve I would be really interested to read on about that topic, but the link is not working. Do you have a new link to this topic?

[Steve]

Re: SELECT() Expression - Google Cloud Community

Expressions: New option for faster and more consis... - Google Cloud Community