Solved: Display content change in ChangeCounter - Page 2

desmond_lee · 03-28-2024 07:47 PM

Hi Guys

One of the feature I like the most is the changeCounter. But that is only show numbers. Is there any to show the content change on the select column?

Suvrutt_Gurjar

Please add an enumlist column called say [Change_Type] with an expression something like below and include it in your emailtemplate.

LIST(
TEXT(IFS([_THISROW_BEFORE].[BARELY]<>[_THISROW].[BARELY], CONCATENATE("Value Before of field Barely: ",[_THISROW_BEFORE].[BARELY]))),

TEXT(IFS([_THISROW_BEFORE].[PARTIALLY]<>[_THISROW].[PARTIALLY], CONCATENATE("Value Before of field Partially: ",[_THISROW_BEFORE].[PARTIALLY])))

TEXT(IFS([_THISROW_BEFORE].[MODERATELY]<>[_THISROW].[MODERATELY], CONCATENATE("Value Before of field Moderately: ",[_THISROW_BEFORE].[MODERATELLY])))

TEXT(IFS([_THISROW_BEFORE].[ MOSTLY]<>[_THISROW].[ MOSTLY],CONCATENATE("Value Before of field Mostly: ",[_THISROW_BEFORE].[MOSTLY])))

TEXT(IFS([_THISROW_BEFORE].[ FULLY]<>[_THISROW].[ FULLY], CONCATENATE("Value Before of field Fully: ",[_THISROW_BEFORE].[FULLY])))

)