Automation bot getting false triggers

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

1 Like

Recategorized this topic as #appsheet-automation.

1 Like

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

3 Likes

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.

1 Like

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

2 Likes

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

2 Likes