Distinguish between old and new record in email bot

Hi everybody,

I wish to create a bot that sends me an email when a record is updated.
In the Body field of the email I can add the variables, but my question is, how can i choose which data should I add?

For example, if want to write "Appointment moved from <<25th of May>>(date before the edit) to the <<1st of June>>(date updated)", how can I do that?

If I use the expression <<[Date]>> it shows me the updated record.

Thanks in advance to anyone! ๐Ÿ˜ƒ

Solved Solved
0 2 117
1 ACCEPTED SOLUTION

You could have a template expression something like 

<<CONCATENATE(โ€œAppointment moved from โ€œ, [_THISROW_BEFORE].[Date] , โ€œ to โ€œ, [_THISROW_AFTER].[Date])>>

Access column values before and after an update - AppSheet Help

 

View solution in original post

2 REPLIES 2

You could have a template expression something like 

<<CONCATENATE(โ€œAppointment moved from โ€œ, [_THISROW_BEFORE].[Date] , โ€œ to โ€œ, [_THISROW_AFTER].[Date])>>

Access column values before and after an update - AppSheet Help

 

Thanks so much, it works!

Top Labels in this Space