# Admin sees all records **URL:** \ **Category:** Ask for Help\ **Created:** [December 29, 2023, 8:40am UTC](https://community.glideapps.com/t/admin-sees-all-records/69089 "2023-12-29T08:40:49Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![jankeyser](https://avatars.discourse-cdn.com/v4/letter/j/f04885/32.png) [@jankeyser](https://community.glideapps.com/u/jankeyser)\ **Post date:** [December 29, 2023, 8:40am UTC](https://community.glideapps.com/t/admin-sees-all-records/69089/1 "2023-12-29T08:40:49Z")
Hi Guys, I just joined and it’s been a journey already to learn the system. From the videos i can get quite a bit of the functionality to work in apps. I would like to know how do I set Admin roles or my staff to see all records created by users related to companies that use the software. Admin = backend Users = frontend ---
**Author:** ![sumgii](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@sumgii](https://community.glideapps.com/u/sumgii)\ **Post date:** [December 29, 2023, 9:33am UTC](https://community.glideapps.com/t/admin-sees-all-records/69089/2 "2023-12-29T09:33:10Z")
Sounds like the same problem as I was tackling last week. I also couldn’t find this in the tutorials. @Darren_Murphy came to my rescue (he does that a lot). Here’s the thread [Help planning out access & authorisation - #4 by sumgii](https://community.glideapps.com/t/help-planning-out-access-authorisation/68946/4) It sounds confusing, but works well. ---
**Author:** ![jankeyser](https://avatars.discourse-cdn.com/v4/letter/j/f04885/32.png) [@jankeyser](https://community.glideapps.com/u/jankeyser)\ **Post date:** [December 29, 2023, 4:05pm UTC](https://community.glideapps.com/t/admin-sees-all-records/69089/3 "2023-12-29T16:05:24Z")
Sounds cool. Going to try this out now. I figured out the Company (customer) and adding the company ID into the user part to accosiate the user with its company part, and I then wrote the Company ID from the user table into the orders that they placed on the front end so that the users can see only the orders for their companies. Let me try the suggestion for admins to then see all records. I will let you know how it goes. ---
**Author:** ![jankeyser](https://avatars.discourse-cdn.com/v4/letter/j/f04885/32.png) [@jankeyser](https://community.glideapps.com/u/jankeyser)\ **Post date:** [December 29, 2023, 5:21pm UTC](https://community.glideapps.com/t/admin-sees-all-records/69089/4 "2023-12-29T17:21:59Z")
So I get this to work when I manually add these values. Whn i do try to do this dynamic via an action it keeps adding the user email address instead of the Company ID Have you done this dynamically ? ---
**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:** [December 29, 2023, 5:40pm UTC](https://community.glideapps.com/t/admin-sees-all-records/69089/5 "2023-12-29T17:40:27Z")
Can you show how your action is configured, and the column that is being written to? ---
**Author:** ![jankeyser](https://avatars.discourse-cdn.com/v4/letter/j/f04885/32.png) [@jankeyser](https://community.glideapps.com/u/jankeyser)\ **Post date:** [December 29, 2023, 6:03pm UTC](https://community.glideapps.com/t/admin-sees-all-records/69089/6 "2023-12-29T18:03:54Z")
Hey Darren, Thanks for assisting See below all the relevant pages. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/6/96537aaadb316fc41fd35a0e69ccd1554ba8a40b.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/4433d4956ec56264652995174060a0e97e5793b2.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fc2222b32530567df7a05d0fe4fc8d491719ee99.png) ---
**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:** [December 29, 2023, 6:15pm UTC](https://community.glideapps.com/t/admin-sees-all-records/69089/7 "2023-12-29T18:15:05Z")
Okay. I think your problem there is that you are trying to set those values using an onSubmit action with a form. What you should do instead is pass the values as column values with the form itself. Review the below docs. > **[Column Values | Glide Docs](https://www.glideapps.com/docs/reference/values/column-values)** > > Column values are the values contained in your data source tables. ---
**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:** [December 29, 2023, 6:18pm UTC](https://community.glideapps.com/t/admin-sees-all-records/69089/8 "2023-12-29T18:18:48Z")
Yeah, if you create a row and immediately are not the owner of that row (On Submit happens AFTER the row is created), then I think Glide will automatically insert the signed in user’s email into any row owner columns so the row doesn’t become orphaned with no row owner. ---
**Author:** ![jankeyser](https://avatars.discourse-cdn.com/v4/letter/j/f04885/32.png) [@jankeyser](https://community.glideapps.com/u/jankeyser)\ **Post date:** [December 29, 2023, 6:19pm UTC](https://community.glideapps.com/t/admin-sees-all-records/69089/9 "2023-12-29T18:19:09Z")
Thank you Darren. I will keep you posted on any progress. Appreciate your input. ---
**Author:** ![jankeyser](https://avatars.discourse-cdn.com/v4/letter/j/f04885/32.png) [@jankeyser](https://community.glideapps.com/u/jankeyser)\ **Post date:** [December 29, 2023, 6:22pm UTC](https://community.glideapps.com/t/admin-sees-all-records/69089/10 "2023-12-29T18:22:01Z")
Hey Jeff So instead of pushing info after the record is created I should pull the info as the record is opened, or rather when the user hits the add new order button? I can see how this is different ---
**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:** [December 29, 2023, 6:23pm UTC](https://community.glideapps.com/t/admin-sees-all-records/69089/11 "2023-12-29T18:23:23Z")
> [@jankeyser](#): > > So instead of pushing info after the record is created I should pull the info as the record is opened, or rather when the user hits the add new order button? No, you should set the owner values when the form is submitted - but not using an onSubmit action. Check the document that I linked you to - it explains how to do that. ---
**Author:** ![jankeyser](https://avatars.discourse-cdn.com/v4/letter/j/f04885/32.png) [@jankeyser](https://community.glideapps.com/u/jankeyser)\ **Post date:** [December 29, 2023, 7:31pm UTC](https://community.glideapps.com/t/admin-sees-all-records/69089/12 "2023-12-29T19:31:07Z")
Okay guys I got this to work just fine. Thanks for all your help to get over this hurdle.