Creating User Securities/Filters with Expressions

[Samuel-MTC]

Hello,

I'm creating my first app using Google AppSheet and have a question regarding User Securities/Filters.

l'm creating an inventory management/ordering app and currently have added all necessary tables and columns that I need to attach products to an order while assigning the order to a specific customer. (Tables: Customers, Orders, Products, Order Details, User Manager). My goal now is to give restricted access to users based on their assigned Group (Enum Column) within my User Manager table, matching that value to the Agent Group (Enum Column) value of my Customers table.

Ultimately I'm trying to restrict access of a user to only have access/create orders for customers of a specific group.

Do I have to duplicate the Customers view and write a "Display>Show if" expression for each customer group?

What "Show if" expression(s) are used to achieve this goal?

If there's any additional information I can provide, please let me know. I look forward to learning together with you all.

Best,

Samuel

[T_I_Phong]

There are many ways to do it, But you can try 2 ways.

in Security -> Security filters:

Users Manager table: IF(USERROLE() = Admin,True, USEREMAIL() = [Email])

Customers table: IN([Agent Group],User Manager[Group])