Workflow question - have a google doc template that I want emailed only when the app status changes.
The rule is set for UPDATE_ONLY with the condition of [AppStatus]=โComplete -โฆโ
the workflow is being triggered anytime an update is made to the record not specifically when the app status changes - how can I fix this?
@Philip_Garrett_Appsh can you use this type of expression for required if?
I tried the following but itโs telling me it canโt find the column _thisrow_before:
OR([_THISROW_BEFORE].[AppStatus] <> [_THISROW_AFTER].[AppStatus], [_THISROW_AFTER].[AppStatus]=โArchivedโ, [_THISROW_BEFORE].[AppStatus] <> [_THISROW_AFTER].[AppStatus], [_THISROW_AFTER].[AppStatus]=โArchived-No Responseโ, [_THISROW_BEFORE].[AppStatus] <> [_THISROW_AFTER].[AppStatus], [_THISROW_AFTER].[AppStatus]=โArchived-Deceasedโ)
@Tammi_Canelli See topic โCompare the Before and After Values of a Columnโ in this article help.appsheet.com - Template Variables
Template Variables help.appsheet.com
If I understood that , then this will work:
AND([_THISROW_BEFORE].[AppStatus] <> [_THISROW_AFTER].[AppStatus], [_THISROW_AFTER].[AppStatus]=โComplete - Accepted (Evac Center)โ)
Looks right.
i want to make the related comments table required if someone archives a recordโฆ
[_THISROW_BEFORE] and [_THISROW_AFTER] only make sense in workflow when doing an add, update, or delete. Only then do we have before and after values to compare.
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |