Combining two expressions for a workflow rule

[Scott_S]

I have one work flow rule that works with out a problem. Then I added some Parent / Child inputs to our Form and needed to follow the actions and new workflow rule for displaying those values on a pdf properly. So I have two expressions and can’t seem to get them correct when combined so they work properly.

THIS ONE FOR THE PARENT/CHILD REQURIEMENT:

AND(
NOT([_THISROW_BEFORE].[SystemProcessed]),
[_THISROW_AFTER].[SystemProcessed]
)

THIS ONE FOR THE NORMAL OPERATION CONDITIONS:

AND(
OR(
[Type] = “Traffic Signal”,
[Type] = “Emergency Traffic Signal”
),
[Status Complete] = “YES”
)

[LeventK]

Scott_S:

THIS ONE FOR THE PARENT/CHILD REQURIEMENT:

AND(
NOT([_THISROW_BEFORE].[SystemProcessed]),
[_THISROW_AFTER].[SystemProcessed]
)

What’s the type of the [SystemProcessed] column? It seems your AND expression syntax is not correct, at least semantically.

[Scott_S]

yes/no

[Scott_S]

Checked a couple more times with testing and I thought it worked but no go still

[LeventK]

@Scott_S
Try with this:

AND(
	ISNOTBLANK([SystemProcessed]),
	NOT([_THISROW_BEFORE].[SystemProcessed] = [_THISROW_AFTER].[SystemProcessed])
)

[Scott_S]

no luck with that one

[LeventK]

From which record are you trying to invoke the workflow? From the parent or from the child?

[Scott_S]

Parent table

[LeventK]

Can you post a screenshot from your workflow settings/details and also from the table you’re invoking the workflow? Thanks.

[Scott_S]

I will- have to set aside for a bit, but will post back. thank you