Data Change Condition Expression only when a certain column is changed

I have an app that uses Google Sheets as a database. The client wants an SMS to be sent every time that the “Status” column changes (if the ‘status’ on row 1 changes, the phone number on row 1 is sent a message.
3X_7_3_7356d8fa733ca8ce14022693ab9da9750cde4c36.png

I have added on the AppSheet Events add-on for google sheets. The client updates the status column in the sheet.

On the appSheet side, I have created an event which fires when an update to the database is called:

However, my condition ([_THISROW_BEFORE].[STATUS] <> [_THISROW_AFTER].[STATUS]) appears to be insufficient. If I add text to the ‘Repair Notes’ column, this event is triggered even though the status is unchanged.

Is this an issue of Google Sheets? Is my condition incorrect? Please help!

0 7 391
7 REPLIES 7
Top Labels in this Space