# Row Owner Is Not Working **URL:** \ **Category:** Ask for Help\ **Created:** [February 1, 2024, 4:56pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377 "2024-02-01T16:56:26Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [February 1, 2024, 4:56pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/1 "2024-02-01T16:56:26Z")
Hello, I have a users glide table, has user email in it, and an overarching admin email column user email column works to set row owners and functions as it should across the glide tables in my app, But when I apply row owner to also the admin email column in my main data table all records are no longer viewable. What am i doing wrong?? Video here: [https://youtu.be/9CO7x2S3O3k](https://youtu.be/9CO7x2S3O3k) ---
**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 1, 2024, 5:00pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/2 "2024-02-01T17:00:30Z")
Normally the Data Editor will refresh when you apply Row Owners. It looks like yours isn’t doing that. If you reload the Builder does it work? ---
**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 1, 2024, 5:00pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/3 "2024-02-01T17:00:54Z")
Couldn’t quite tell in the video. Do you have multiple emails in that admin email column? ---
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [February 1, 2024, 5:03pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/4 "2024-02-01T17:03:14Z")
I have only one email per column, and I refreshed everything and nothing ever changes, also reloading a live app (not in editor) all data disappears because it appears to think its not row owner just to reiterate, it works for the user email column, but it is not working on the admin email column which I find very bizarre ---
**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 1, 2024, 5:05pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/5 "2024-02-01T17:05:34Z")
oh, I see the problem. You’re giving each user two email addresses. That won’t work. You need to use Roles as Row Owners. ---
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [February 1, 2024, 5:08pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/6 "2024-02-01T17:08:17Z")
i also tried to apply row owners to SHOP ACCOUNT column in both sheets, and it still did not work?? Does the column header have to say “roles”? ---
**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 1, 2024, 5:10pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/7 "2024-02-01T17:10:01Z")
Yeah for clarification, setting row owner in the user table only determines who has access to that user row. It does nothing to determine row ownership in other tables. If none of your users are signed in with the claim email, then none of them will be able to access any rows only owned by the claim user. > **[Roles | Glide Docs](https://www.glideapps.com/docs/essentials/security-and-user-data/roles)** > > Define roles for your users and build different experiences and permissions. ---
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [February 1, 2024, 5:12pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/8 "2024-02-01T17:12:54Z")
OK that explains why it worked with a google sheet, but doesnt work now that glide changed pricing and forced me to move this monstrous app into a glide table, it has its pros and cons. Mostly pros using glide tables for speed. however this is a downer. Is there a way then that within glide tables to have 3 row owner columns, specifically in the user sheet. use case: all company employees get same account number, but each user has a different role, and a different user email. Because this app will span across many business’s with different account numbers i dont want that data going to any device except the intended business ---
**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 1, 2024, 5:16pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/9 "2024-02-01T17:16:04Z")
The only difference from Google sheets is that you can’t create server side arrays to use for row owners. You could always have multiple columns as row owners. But since you have multiple admin users, it’s a lot easier to set them up with Role functionality, give all users the role of admin, and then write the word admin to a row owner column in all of your other tables. ---
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [February 1, 2024, 5:17pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/10 "2024-02-01T17:17:16Z")
This works and doesn’t work. I need to have roles admin, technician, refinish etc. So that the app interface only loads the data necessary for those users. But then I also need the account number role functionality due to reasons stated above. can I have 3 row owner columns in the user table? ---
**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 1, 2024, 5:18pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/11 "2024-02-01T17:18:50Z")
Your user table only needs an email column for the specific user, an admin column where you write admin in all rows, and a role column where you assign admin to users that need it. Then configure the roles in the user profile configuration to point to that role column. ---
**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 1, 2024, 5:19pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/12 "2024-02-01T17:19:05Z")
> [@Myles\_Chaput](#): > > But then I also need the account number role functionality due to reasons stated above. can I have 3 row owner columns in the user table? You can have as many row owner columns as you want, but you are limited to one role per user, or nine if you use a Google Sheet as your Users table. ---
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [February 1, 2024, 5:25pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/13 "2024-02-01T17:25:40Z")
is there any way to use the SHOP ACCOUNT column to make this happen?? ---
**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 1, 2024, 5:31pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/14 "2024-02-01T17:31:14Z")
Yeah, you can use any basic column you want as row owner (provided it contains a user role or email). When setting up roles in the user profile configuration, you are telling glide which column in your user table will contain the role assigned to a user. Then when you assign row owners to columns in your tables, it checks if the signed in user’s email or the signed in user’s role matches the value in any row owner columns. If it matches, then they are an owner of the row. ---
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [February 1, 2024, 5:37pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/15 "2024-02-01T17:37:11Z")
It is interesting then to me that this isn’t working the way its described. I just tried that can you check my video: [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cdb75ba19e344ce9a175f3f21dce8be10972b96d.jpeg "2024 02 01 11 34 40") ](https://www.youtube.com/watch?v=pq0AHBrif2o) ---
**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 1, 2024, 5:39pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/16 "2024-02-01T17:39:50Z")
Again, setting Row Owners in the user table has no bearing on row owners in other tables. Have you gone through the documentation I shared above that explains how to configure Roles? Also for more reference…how to configure user profiles. > **[User Profiles | Glide Docs](https://www.glideapps.com/docs/essentials/security-and-user-data/user-profiles)** > > Define, store, and use data on your app's users. ---
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [February 1, 2024, 5:42pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/17 "2024-02-01T17:42:07Z")
Yes I did I guess the hang up here is that I am assuming my “shop account” column could function as Roles instead of the actual Roles column. ---
**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 1, 2024, 5:42pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/18 "2024-02-01T17:42:46Z")
It can 100%. You just need to configure in the user profile configuration to use that Shop Account column for Roles. ---
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [February 1, 2024, 5:44pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/19 "2024-02-01T17:44:55Z")
I am missing something so obvious here, How do I assign “shop account” to be the Roles column? I am trying to avoid alot of rework by changing the many screens of visility conditions based on the current “Role” Column. ---
**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 1, 2024, 5:53pm UTC](https://community.glideapps.com/t/row-owner-is-not-working/70377/20 "2024-02-01T17:53:38Z")
![Screenshot_20240201-115231](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/4/b4340e4d46abd5902261e8b49a0ec7d19f403e66.png) [Next page](https://community.glideapps.com/t/row-owner-is-not-working/70377.md?page=2)