Specifying what changed in a record in an email notification

BenBl
New Member

Hey all,

I have an email notification sent every time a record is changed. This is great. But I would like to highlight, bold, or announce the column that was changed. E.g. if I have the columns orderid, status, product, and a user changes the product entry, I would like the notification to say โ€œUSEREMAIL() updated the product column from Product A to Product B at NOW()โ€. Now, in reality, I have 10 columns, some of which have child records.

My current approach is:

<<If: [_THISROW_BEFORE].[Status] <>[_THISROW].[Status]>> 
<<USEREMAIL()>> changed status from <<[_THISROW_BEFORE].[Status]>> to <<[_THISROW].[Status]>>
<<EndIf>>

The issue is: I donโ€™t want to copy and paste this for every column and I donโ€™t want to change it every time I update a column name or add a column.

Is there something built in to do this? (ideal) if not, is there a way to iterate through every column automatically?

1 4 627
4 REPLIES 4
Top Labels in this Space