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:
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.
Check out IFS() or SWITCH()
SWITCH( {{current user role}} , "super admin" , TRUE , "inst admin" , [inst]=xx , "controller" , ... )
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 .
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |