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.
Solved! Go to Solution.
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.
Try something likeโฆ
<< IF:AND(
[_THISROW_BEFORE].[ColA]<>[_THISROW_AFTER].[ColA],
ISNOTBLANK([ColA])
) >>
<< [_THISROW_BEFORE].[ColA] >>
<< [_THISROW_AFTER].[ColA] >>
<< EndIf >>
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.
Thank you
Youโre welcome
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |