triggering my bot

AppSheet AppSheet Q&A
1

Hi,

I am trying to get my bot to send off an email when I update my field=[Gift Status]=“Received”.

This expression isn’t quite working for the condition area.

AND([Gift Status]=“Received”,[_THISROW_BEFORE].[Gift Status]<>[_THISROW_AFTER].[Gift Status])

ALL these statements are true: …1: (The value of column ‘Gift Status’) is equal to (“Received”) …2: (The value of ‘Gift Status’ from the row referenced by ‘CnBio_ID’) is not equal to (The value of ‘Gift Status’ from the row referenced by ‘CnBio_ID’)

Why is the statements referencing my other field called “CnBio_ID”?

2

It sounds that the field [CnBio_ID] is the key column of the table. [_THISROW_BEFORE] and [_THISROW_AFTER] identifies the specific current record with the help of the key column. Thereafter [_THISROW_AFTER].[Column Name] and [_THISROW_BEFORE].[Column Name] identify the column value before and after change in the said specific row. I believe evaluation explanation statement is just stating that.