Help with an expression And(OR

AppSheet AppSheet Q&A
1

I have this in the Security table settings and it works as it is written.

AND([Employee Email]=USEREMAIL(),[Status]=“Pending”)

However, I need to add another layer.

I need to include another the name of the person who created the original record. this being stored in useremail column in the Master Table

And(Or([Employee Email]=USEREMAIL(), useremail=USEREMAIL(),[Status]=“Pending”))

I get Condition And(Or([Employee Email]=USEREMAIL(), useremail=USEREMAIL(),[Status]=“Pending”) has an invalid structure: at least 2 subexpression(s) are required

I dont understand expressions enough to change it.

I should not have used useremail as the column name but I should have used created by.

is it ok to change the column header in the data table to something else without disturbing anything in the app?

Thanks

2

You need to restructure your statement to something similar to this:

OR([useremail]=USEREMAIL(),AND([Employee Email]=USEREMAIL(),[Status]="Pending"))

Anytime you use AND()/OR() each iteration of one or the other requires at least two subexpression within themselves.

1 Like
3

You forgot to close the parenthesis of te OR before concludinf with the AND final condition.
Try:

AND(
OR([Employee Email] = USEREMAIL(), [Master Table].[useremail] = USEREMAIL()),
[Status] = “Pending”
)