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!
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |