Add more emails to "Are updates allowed?"

[sainikhushdeep]

I have 3 tables which are not related. I want to add more than one user to access.
The default expression is:
SWITCH(USEREMAIL(),
“user1@mydomain.com”, “UPDATES_ONLY”,
“user2@mydomain.com”, “ALL_CHANGES”,
“READ_ONLY”)
I want like: “ks@gmail.com” “ks1@gmail.com”, “UPDATES_ONLY”

OR

I have a google sheet which contains emails with their respective role. I can assign limitaion depending on role. Either way will work for me.
Thank You.

[Suvrutt_Gurjar · Accepted solution]

You could try an expression something like below

IFS(
IN(USEREMAIL(), SELECT(Email List Table[Email],[Role]=“Senior Manager”)) , “UPDATES_ONLY”,
IN(USEREMAIL(), SELECT(Email List Table[Email],[Role]=“Manager”)), “ALL_CHANGES”,
IN(USEREMAIL(), SELECT(Email List Table[Email],[Role]=“Observer”)),“READ_ONLY”)

Please replace with suitable actual names of tables, roles, columns in your case.

The below article discusses filter expressions on similar lines.

help.appsheet.com

Security Filters: The Essentials

You can use Security Filters to control which records a user can see and update.