Condition on Data Change Event Not Applying

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!

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?

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,

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.

1 Like

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!

1 Like