Template to show only adds and updates (new and old line only)

Good evening all,

When the workflow sends out the report on adds and updates, I only want to show the old line and updated line only, next to each other.
Example question

What is your age?
Old line 34
Updated line 35

(do not show any items which has not changed)

Can anyone help me with this.
Thank in advance for the help.

Try something like…

<< IF:AND(
[_THISROW_BEFORE].[ColA]<>[_THISROW_AFTER].[ColA],
ISNOTBLANK([ColA])
) >>
<< [_THISROW_BEFORE].[ColA] >>
<< [_THISROW_AFTER].[ColA] >>
<< EndIf >>

1 Like

Aleksi,
I added my row detail to your recommended formula

<< If:AND([_THISROW_BEFORE].[1.Condition of Vehicle Scanning Equipment]<>[_THISROW_AFTER].[1.Condition of Vehicle Scanning Equipment],

ISNOTBLANK([1.Condition of Vehicle Scanning Equipment])

) >>

<< [_THISROW_BEFORE].[1.Condition of Vehicle Scanning Equipment]>>

<< [_THISROW_AFTER].[1.Condition of Vehicle Scanning Equipment]>>

<< EndIf >>

Error in test section in AppSheet
Failed: Action not performed because 1 errors are present. Error: Workflow rule 'Update TPR ’ action ‘New TPR completed’ Body template. Found 1 unmatched ‘EndIf’. They are:

<< EndIf >>

.

If I remove EndIf this is want
Failed: Action not performed because 1 errors are present. Error: Workflow rule 'Update TPR ’ action 'Updated TPR ’ Body template. Expression ‘If:AND([_THISROW_BEFORE].[1.Condition of Vehicle Scanning Equipment]<>[_THISROW_AFTER].[1.Condition of Vehicle Scanning Equipment],ISNOTBLANK([1.Condition of Vehicle Scanning Equipment]))’ is invalid due to: Unable to find function ‘IF:AND’, did you mean ‘FIND’?..

I just used the first question to get working and the will add to the rest of the template questions.

Can you help please.

Thanks

I made a test with…

<<IF:AND([_THISROW_BEFORE].[DATA]<>[_THISROW_AFTER].[DATA],ISNOTBLANK([DATA]))>>
<<[_THISROW_BEFORE].[DATA]>>
<<[_THISROW_AFTER].[DATA]>>
<< EndIf >>

Please check that you don’t have any spaces with the formula.

1 Like

Thank you :+1:

You’re welcome