Just checking as I’ve got a workflow behaving a bit strangely. So it should trigger with the following formula if the used clicks an action button which sets [Report]=“Email” and then back to [Report]="". Or if [Verified] changes from FALSE to TRUE.
OR(
AND([Report]=“Email”,[Type]=“OTDR SATC”)
,
AND(
[_ThisRow_BEFORE].[Verified]=FALSE,
[_ThisRow_AFTER].[Verified]=TRUE)
)
What it actaully happening is that changing [Verified] to TRUE seems to trigger all 15 workflows on that table. Should it be this instead?
OR(
AND([Report]=“Email”,[Type]=“OTDR SATC”)
,
AND(
[_ThisRow_BEFORE].[Verified]<>[_ThisRow_AFTER].[Verified],
[Verified]=TRUE
)
or with this addtion only the workflow related to that [type] runs?
OR(
AND([Report]=“Email”,[Type]=“OTDR SATC”)
,
AND(
[Type]=“OTDR SATC”,
[_ThisRow_BEFORE].[Verified]<>[_ThisRow_AFTER].[Verified],
[Verified]=TRUE
)
asking this as a question rather that just testing as its a live app used permanently. So need to get it right first time
Screenshot of the workflow configuration?
Can’t - personal data. But
Set to updates only
Google Docs attachment template
Attach & archive set with a specified folder path
Everything else is default
Do this instead:
OR(
AND([Report]="Email", [Type]="OTDR SATC"),
[_THISROW_BEFORE].[Verified]<>[_THISROW_AFTER].[Verified]
)
Maybe try this?
AND([Report]=“Email”,[Type]=“OTDR SATC”, [_ThisRow_BEFORE].[Verified]<>[_ThisRow_AFTER].[Verified],
[Verified])
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |