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! Go to 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
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!
User | Count |
---|---|
15 | |
11 | |
10 | |
8 | |
3 |