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?