In my inventory management application, I have two types of users: members and admins. These users are all in the same Users table. Members have access to the operations they have performed, but admins have access to all operations. When I use Glide’s Row Owner feature, admins don’t have access to the names of those who performed the operations. To give them access, I need to add a column for each admin and apply the Row Owner functionality. Please,
How can I make it so that admins have access to the first and last names of other users while using Row Owner, or is there another way to allow admins to know who recorded each operation?
Staff members have access to the operations that they themselves performed? Or staff members have access to the operations that they themselves performed and all operations of other staff members?
In the operations table, I think you would set things up as follows:
- An “Admin Ownership” column. Apply row ownership. Populate each row with the text “Admin” (the term you use for admins in the Users table in the Role column).
- A “Staff Ownership” column. Apply row ownership. Populate rows that need to be owned (seen/edited/deleted) by all staff members with the text “Staff”.
- A “User Ownership” column. Apply row ownership. Populate rows that need to be owned by the user only and nobody else with the user’s email.
Each column in tables that are not the Users table is an ownership level. You define who belongs to the ownership level in the Users table.
1 Like
(post deleted by author)
Thank you for your response, but I would like to answer your question.
Staff members have access to the operations that they themselves performed. Admin members have access to the operations that they themselves performed and all operations of other staff menbers.