LOOKUP(USEREMAIL() Table does not allow this operation

Hi, I am struggling with privileges and security filters…
I want to give edit privileges to specific users and limit them to view related projects by using staff table,
but getting this error “Table does not allow this operation”.

STAFF TABLE

with the formulas

for privileges
LOOKUP(USEREMAIL(),"STAFF","EMAIL","PRIVILEGE")

for security filters
IN(LOOKUP(USEREMAIL(),"STAFF","EMAIL","PROJECTS"),[PROJECT])

I want
Morpheus to view all projects but READ_ONLY
Mr Anderson to view all projects and make ALL_CHANGES in all projects
TANK to view worlds and make UPDATES_ONLY
Trinity to view projects that she is related but READ_ONLY

Thank you all…

@LeventK @Steve

Solved Solved
0 13 1,108
1 ACCEPTED SOLUTION

So, I have worked around and noticed that, formula is actually working perfect when user sign in from the phone.
But in the preview pane in appsheet editor confused me giving error, bizarre!

LOOKUP(USEREMAIL(),"STAFF","EMAIL","PRIVILEGE")

View solution in original post

13 REPLIES 13
Top Labels in this Space