Combining two expressions for a workflow rule

AppSheet AppSheet Q&A
1

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

2

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.

3

yes/no

4

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

5

@Scott_S
Try with this:

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

no luck with that one

7

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

1 Like
8

Parent table

9

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

1 Like
10

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

1 Like