Condition on Data Change Event Not Applying

[jthurston]

Hello,

I created a bot that keeps track of all the classes our students have been in. When a student’s class is changed in AppSheet, the bot creates a record in an Enrollment History table. Or at least, that’s the goal.

My issue is that the condition seems to be ignored. The bot is triggering on any change to the record, instead of changes to the class column. Is my expression wrong? I could have sworn it was working as intended last week, with no changes. But maybe I forgot to double-check that other changes wouldn’t trigger the bot.

Thank you!

[WillowMobileSys]

This looks correct. I would suggest to have your sheet open and watch it closely after the Save. Does the Class column change in anyway during that save?

How is your Class column implemented? Is it a user selected value column or is there an App Formula expression assigned?

[jthurston]

Hi John,

Thank you for reaching out, and for your help! I changed another column and saved. I did not notice anything changing in the Class column. It was blank, both before and after. But it still created the new Enrollments entry.

The Class Column is user-selected from a dropdown. It’s a REF column that connects to the Classes table. No expressions are used for column value.

Thank you,

[WillowMobileSys]

Are there any other bots that could be adding the row instead of this one?

Make sure your bot changes have really been saved. Close the app and re-open and re-inspect the Bot to make sure the expression is still there.

If so, then try replacing the expression with `ISNOTBLANK([Class])’ and run your same test. If you still get a row added then there is either a bug or something else within your app is causing the row to be added.

[jthurston]

Hi John,

I’m pretty sure there are no other bots that interact with the Enrollments table. I’ll give those other things a try and report back.

Thank you!

[jthurston]

So it’s working now. No reason I can understand. It just started working, with the exact same formula. shrug

[SkrOYC]

Justin_Thurston:

The bot is triggering on any change to the record, instead of changes to the class column

Check if Class is blank.
You could wrap your expression with AND() adding ISNOTBLANK([Class])

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

Trigger Workflow With A Simple Action Button Tips & Tricks 💡

There it is! I tested both of my tables that has the setup I described above and both of them trigger the event when the column is blank. I guess I’m gonna make them default to 0 or change it to a more elegant solution as @MultiTech_Visions and @Grant_Stead are doing. Thanks again @Marc_Dillon. I told you that you were a very helpfull person!

[jairod]

This fixed the same problem for me. On updating one column, multiple bots with change filters were triggering. With the use of and(....isnotblank)) only the bot triggered by the changed column was activated.