Solved: Help with an expression And(OR - Page 2

RickM · 02-21-2024 08:24 AM

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

romulo_torres

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

View solution in original post