Returns the role assigned to the user (such as
User. You cannot add or remove roles.
IF((USERROLE() = "Admin"), "ALL_CHANGES", "UPDATES_ONLY"), when used as a table's
Are updates allowed? expression, allows an approved user with the
Admin role full access to the table while allowing all other users only update access.
(USERROLE() = "Admin"), when used as a column's
Edit_If expression, allows only approved users with the
Admin role to view or edit the column.
OR((USEREMAIL() = [Email]), (USERROLE() = "Admin")), if used as a security filter expression, includes the row if the
Admin role (allowing an
Admin to access all rows).
USERROLE() is only applicable if the app requires user sign-in.