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

[Aurelien]

Hi @PG3

@PG3

• 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