Workflow trigger acting strange

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

0 4 194
4 REPLIES 4

Steve
Platinum 4
Platinum 4

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

Bahbus
New Member

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])

Top Labels in this Space