Send notification after a row update

AppSheet AppSheet Q&A
1

Hi,

I have a bot that is checking for a column (“status”) to be changed in rows of a table (“kits”).

This works fine.

I then want it to trigger a notification to a user whose email is stored in the same row that has been updated only (“reserved by”).

No matter what I try, it is notifying all users whose email is in the “reserved by” column of any row.

How do I reference the column in only the row that has just been updated?

Thanks. (Also first time posting, been using Appsheet for a while and found answers in these forums most helpful, thanks!)

2

Can you explain what filter condition you are using to trigger the automation?

3

In documenting this for you I spotted an issue that ended up resolving it by the looks.

This new setup seemed to work:

Event type: Data change

Table: “Kits”

Data change type: “Updates”

Condition: “AND([_THISROW_BEFORE].[Status] <> [_THISROW_AFTER].[Status],[Status]=“1”)”

==

Then “Send a Notification Task”

To: “[_thisrow].[Reserved by]”

Appears to do the trick!