# Roles, Admin, Users **URL:** \ **Category:** Ask for Help\ **Created:** [February 20, 2024, 7:33am UTC](https://community.glideapps.com/t/roles-admin-users/70986 "2024-02-20T07:33:27Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![vedran\_nincevic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vedran_nincevic/32/69441_2.png) [@vedran\_nincevic](https://community.glideapps.com/u/vedran_nincevic)\ **Post date:** [February 20, 2024, 7:33am UTC](https://community.glideapps.com/t/roles-admin-users/70986/1 "2024-02-20T07:33:27Z")
Hi, my Glide app is a driving working order app for tourism industry. So, my tables in Airtable are vehicles, drivers, clients, work orders, reports. I want each driver to see only his own Work orders, and Admin to see all Work orders. If I filter “Name Surname from table Drivers IS User Name”, each driver gets his own work orders ![GlideFilter200223](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/43654350dcc4d72f8d87d86597a44ba21a76af9f.png) ![GlideWOVN200223](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/3/233ec508953a7d10fcac26acfc385beb40c7a6aa.png) This is what I want for each driver, but Admin cannot see any work order ![GlideWOadmin200223](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d6df07100b85d32deec24377ea0f8caa88723703.png) My Users table: ![GlideUsers200223](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/464dad2d8daa7e732c798f149a00ead09a87c66f.png) Glide is a fantastic tool and I am going to make 3-4 more apps 🙂 Thank you very much all ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 20, 2024, 9:51am UTC](https://community.glideapps.com/t/roles-admin-users/70986/2 "2024-02-20T09:51:39Z")
In your last screenshot, I see a column named “Uloga” - is that the column that is set as the Role in your User Profiles configuration? If yes, then I would suggest the following: - Remove Row Owners from that column (it isn’t required) - Create another text column and name it something like “Admin Owner”. Make that column a Row Owner, and add the word “Admin” in every row. That should solve your problem. ---
**Author:** ![vedran\_nincevic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vedran_nincevic/32/69441_2.png) [@vedran\_nincevic](https://community.glideapps.com/u/vedran_nincevic)\ **Post date:** [February 20, 2024, 3:56pm UTC](https://community.glideapps.com/t/roles-admin-users/70986/3 "2024-02-20T15:56:53Z")
Thank you for quick answer… But still Admin can’t see all Work Orders… My Users table (yes, Uloga is Role) ![GlideUsers200224](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/b/0b04238d13e02ddea41fbf325368c9f64629d6f1.png) Drivers table ![GlideDrivers200224](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/4/34696ec2740906aecd4b755688ff25a360d9b2f3.png) Work Orders table ![GlideWorkOrders200224](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/808ce8683ac6e7211438f5087a0b89baf038516d.png) Work Order Collection viewed as user (driver) Goran Ivanisevic, when filtered “Name Surname from Drivers is Username” ![GlideshWOGI200224](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/2/c2ece6b88fd5c843367c8acceff7d3dd8280e055.png) Maybe somehow to “link” Admin Role to Work Order table? Because when I filter data, I can filter only by Work Orders columns, and there is no link between Work Orders table and Admin Role. In Airtable there is no link between Users and Drivers, maybe that is the problem?? Sorry for this long post, I don’t see a solution, and I am very confused… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 20, 2024, 4:10pm UTC](https://community.glideapps.com/t/roles-admin-users/70986/4 "2024-02-20T16:10:33Z")
Please show me your User Profiles configuration. Go to Settings → Users & Authentication → Edit user profile ---
**Author:** ![vedran\_nincevic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vedran_nincevic/32/69441_2.png) [@vedran\_nincevic](https://community.glideapps.com/u/vedran_nincevic)\ **Post date:** [February 20, 2024, 6:53pm UTC](https://community.glideapps.com/t/roles-admin-users/70986/5 "2024-02-20T18:53:11Z")
Here it is: ![GlideUserNV](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4d91f2005c1ffe966e1a296726895aa56fd72093.png) But when I originally signed in Glide, I did with this user: ![GlideUserVN](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c0c81d6c3b541a14eb37a666f159e52f9f6277ac.png) Currently I am on Legacy Starter plan Thank you very much for your help ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 20, 2024, 7:11pm UTC](https://community.glideapps.com/t/roles-admin-users/70986/6 "2024-02-20T19:11:01Z")
Do you have any Row Owner columns in your Driver and Work Order tables? ---
**Author:** ![vedran\_nincevic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vedran_nincevic/32/69441_2.png) [@vedran\_nincevic](https://community.glideapps.com/u/vedran_nincevic)\ **Post date:** [February 21, 2024, 6:27am UTC](https://community.glideapps.com/t/roles-admin-users/70986/7 "2024-02-21T06:27:41Z")
No, I have no Row Owner columns in Driver table or in Work Orders table. Drivers table ![GlideDrivers210224](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/4/b446c9f01fa5fa16bce604ec30601c2721b8b993.png) Work Orders table ![GlideWO210224_1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aadcff6a0ad3ffe488f583d5615ed001ba4a9197.png) ![GlideWO210224_2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/6/167bab3ae4d7a1aa08d77a2ca206b1455f93e93f.png) ![GlideWO210224_3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/4/04891ac5b444b1f4ffb8b241f8f1b509c6adacfa.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 21, 2024, 7:09am UTC](https://community.glideapps.com/t/roles-admin-users/70986/8 "2024-02-21T07:09:33Z")
Ideally you would not use filters and instead have two Row Owner columns in each of those tables. One column would contain the email address of the driver, and the other would contain the the word ‘Admin’ to match your admin role. That would grant each driver access to only their own rows and the admin access to all rows. Row owners are more secure than filters, but if you prefer to use filters instead of row owners, then you need a template column to place the word ‘Admin’ on all rows, and then add an additional filter that checks if that template column matches the role value in the user profile. ---
**Author:** ![vedran\_nincevic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vedran_nincevic/32/69441_2.png) [@vedran\_nincevic](https://community.glideapps.com/u/vedran_nincevic)\ **Post date:** [February 22, 2024, 5:56pm UTC](https://community.glideapps.com/t/roles-admin-users/70986/9 "2024-02-22T17:56:31Z")
Thank you very much I managed to get each Driver to see their own Work Order, and Admin to see all Work Orders I did it by adding If =) Then=) Else column in Work Orders table I learned some important things for developing future Glide apps. If you have Airtable base, a new column in Glide (user specific column, not from Airtable) cannot be Row Owner column. When creating Airtable base, it is very important to link tables on User =) Username email column. Next time I will make Username email the primary field in Airtable User table 🙂 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 22, 2024, 6:04pm UTC](https://community.glideapps.com/t/roles-admin-users/70986/10 "2024-02-22T18:04:15Z")
> [@vedran\_nincevic](#): > > I managed to get each Driver to see their own Work Order, > and Admin to see all Work Orders > I did it by adding If =) Then=) Else column in Work Orders table You do understand that is not fully secure, yes? > [@vedran\_nincevic](#): > > If you have Airtable base, a new column in Glide (user specific column, not from Airtable) cannot be Row Owner column. Yes, a User Specific column cannot be a row owner. However, if you created those columns in Airtable instead of Glide as simple text columns, then let them sync to Glide, Glide would then allow you to use them as Row Owners. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [February 29, 2024, 6:04pm UTC](https://community.glideapps.com/t/roles-admin-users/70986/11 "2024-02-29T18:04:36Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.