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?
User | Count |
---|---|
31 | |
13 | |
3 | |
3 | |
2 |