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”.
with the formulas
for privileges
LOOKUP(USEREMAIL(),"STAFF","EMAIL","PRIVILEGE")
for security filters
IN(LOOKUP(USEREMAIL(),"STAFF","EMAIL","PROJECTS"),[PRO
JECT])
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…
Solved! Go to 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")
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |