'Are updated allowed' Expression based on Roles, not emails

[PG3]

Hi there,

I am looking for an Expression for the update mode in a table based on Roles in a Permission table rather than based on email addresses.

Want I ant to achieve:

• Allow ADMIN Role in Permissions table (ID, Role, Email) to have ALL CHANGES rights
• Allow all USER Roles in Permissions table (ID, Role, Email) to have only ADD and UPDATE rights only
• Allow PM Role in Permissions table (ID, Role, Email) to have UPDATE and DELETE rights only

Thanking you in advance.

[Aurelien · Accepted solution]

Hi @PG3 

---

@PG3 wrote:

• Allow ADMIN Role in Permissions table (ID, Role, Email) to have ALL CHANGES rights
• Allow all USER Roles in Permissions table (ID, Role, Email) to have only ADD and UPDATE rights only
• Allow PM Role in Permissions table (ID, Role, Email) to have UPDATE and DELETE rights only

---

Can you try:

SWITCH(LOOKUP(USEREMAIL(), "Permissions", "Email", "Role"), 
  "ADMIN", "ALL_CHANGES",
  "USER", "ADDS_AND_UPDATES",
  "PM", "UPDATES_AND_DELETES", 
  "READ_ONLY")

 For reference:

LOOKUP() - AppSheet Help