Row_Filter_Expressions

[Mholi]

I have a User Manager table with the following columns: ID, Name, Surname, Email, Role, and Institution. The Institution column is a reference type, referencing the Water Treatment Works table.

In the User Manager table, the Role column is an enum data type with the values Super Admin, Institution Admin, and Process Controllers.

I have the following requirements for row filtering in a slice view of the Water Treatment Works table:

1. Super Admin: Should see all rows in the Water Treatment Works table.
2. Institution Admin: Should only see rows with the same Institution name as their own.
3. Process Controllers: Should only see rows corresponding to their specific Water Treatment plant, based on their email.

I would like assistance in formulating an AppSheet formula that can be used to achieve this row filtering in my slice view of the Water Treatment Works table.

[Marc_Dillon]

Check out IFS() or SWITCH()

SWITCH( {{current user role}} , "super admin" , TRUE , "inst admin" , [inst]=xx , "controller" , ... )

[dbaum]

See SUMMARY TIP: User permissions, roles, and settings - Google Cloud Community  especially the "Custom user metadata" section and its linked tip,  Current User (Slice) | How to conform your app a... - Google Cloud Community .