Bot Email format for ANY changed columns

[John_666]

Hi,

Is there an email body expression that when any column in a row is changed, only the changed column values are returned in the email body? eg. If the bot is set to email on any change event in the row, the report email specifies only the column values that have changed and leaves out the unchanged column values.

Many thanks

[Aurelien]

Hi @John_666

Use this syntax:

<<If:[_THISROW_BEFORE].[columnName]<>[_THISROW_AFTER].[columnName]>>NewValue: <<[columnName]>> <<EndIf>>

That gives this for example:

Template:

Output:

As you may have noticed it, you will have to replicate this kind of expression for each column that you wish to track.