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.
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!