Workflow question - have a google doc templat...

workflow
(Tammi Canelli) #1

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?

(Tammi Canelli) #2

@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”)

(Philip Garrett) #3

@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

(Tammi Canelli) #4

If I understood that , then this will work:

AND([_THISROW_BEFORE].[AppStatus] <> [_THISROW_AFTER].[AppStatus], [_THISROW_AFTER].[AppStatus]=“Complete - Accepted (Evac Center)”)

(Philip Garrett) #5

@Tammi_Canelli

Looks right.

(Tammi Canelli) #6

@Philip_Garrett_Appsh

Thanks - it worked!

Things are starting to come together :slight_smile:

(Tammi Canelli) #7

i want to make the related comments table required if someone archives a record…

(Philip Garrett) #8

@Tammi_Canelli

[_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.

(Tammi Canelli) #9

@Philip_Garrett_Appsh

ok thanks.

I’ll come up with something else.