# Row owners - groups/roles and relations **URL:** \ **Category:** Ask for Help\ **Tags:** row-owners\ **Created:** [June 28, 2024, 3:37pm UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453 "2024-06-28T15:37:32Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Itai\_Peer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/itai_peer/32/75705_2.png) [@Itai\_Peer](https://community.glideapps.com/u/Itai_Peer)\ **Post date:** [June 28, 2024, 3:37pm UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/1 "2024-06-28T15:37:32Z")
Hi there everyone! šŸ˜Š Iā€™m trying to set up user-specific data visibility using row owners in my Glide app and need some assistance. Hereā€™s the scenario: My app serves about 20 separate companies, each identified by a unique `company_id`. In the ā€œcall\_logā€ table, I have 12,500 rows of data containing entries for all companies. Each row has a `company_id` column that specifies the company the row belongs to. I want to have flexibility when it comes to users and roles. For example, these would be the types of user configurations you might see in the app: - User1 can see the data for only one specific company. - User2 owns 5 of the companies, so he can see the data for these 5 companies. - User2 also has a manager (User3) for two of his companies, so he wants this manager to be able to view the data for 2 of the 5 companies. Iā€™m having trouble finding a topic that explains how to set this up. Any help would be appreciated! Thank you! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 29, 2024, 12:19am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/2 "2024-06-29T00:19:08Z")
Youā€™re likely looking at a roles column that contains an array of IDs a user can see. May I know which data source youā€™re using? ---
**Author:** ![Itai\_Peer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/itai_peer/32/75705_2.png) [@Itai\_Peer](https://community.glideapps.com/u/Itai_Peer)\ **Post date:** [June 29, 2024, 7:57am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/3 "2024-06-29T07:57:36Z")
Thanks, The data source is in Google sheets, the Users table is a Glide 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:** [June 29, 2024, 8:25am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/4 "2024-06-29T08:25:04Z")
Thatā€™s a shame. You should consider making the Users table a Google Sheet. This will give you the opportunity to define up to 9 roles per user, which should be useful in your case. With native Glide tables, you are restricted to one role per user. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 29, 2024, 1:18pm UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/5 "2024-06-29T13:18:54Z")
> [@Darren\_Murphy](#): > > With native Glide tables, you are restricted to one role per user. Just throwing ideas here, I havenā€™t actually tried this, does a basic array like the multiple files column support roles? ---
**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:** [June 29, 2024, 1:28pm UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/6 "2024-06-29T13:28:57Z")
hehe, no. I wish it did šŸ™‚ ---
**Author:** ![Itai\_Peer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/itai_peer/32/75705_2.png) [@Itai\_Peer](https://community.glideapps.com/u/Itai_Peer)\ **Post date:** [June 29, 2024, 2:58pm UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/7 "2024-06-29T14:58:17Z")
Ok, thanks! How do I implement my scenario after I transition to G sheets users table? ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 29, 2024, 4:15pm UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/8 "2024-06-29T16:15:04Z")
To create an array of roles in GSheet name the columns the same and increment the number at the end by one I.e. role1, role2, role3, etcā€¦ If you follow that naming scheme and put the columns next to each other then Glide will automagically create an array ---
**Author:** ![mrt224](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mrt224/32/490_2.png) [@mrt224](https://community.glideapps.com/u/mrt224)\ **Post date:** [June 30, 2024, 1:45am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/9 "2024-06-30T01:45:07Z")
how do you set-up roles that have multiple roles per user in google sheets ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 30, 2024, 1:56am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/10 "2024-06-30T01:56:25Z")
Like what @Eric_Penn described above. ---
**Author:** ![mrt224](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mrt224/32/490_2.png) [@mrt224](https://community.glideapps.com/u/mrt224)\ **Post date:** [June 30, 2024, 2:08am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/11 "2024-06-30T02:08:00Z")
Ok. Why up to 9 & not more? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 30, 2024, 2:35am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/12 "2024-06-30T02:35:18Z")
Thatā€™s the platformā€™s limit. ---
**Author:** ![mrt224](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mrt224/32/490_2.png) [@mrt224](https://community.glideapps.com/u/mrt224)\ **Post date:** [June 30, 2024, 2:46am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/13 "2024-06-30T02:46:16Z")
thank you ---
**Author:** ![Itai\_Peer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/itai_peer/32/75705_2.png) [@Itai\_Peer](https://community.glideapps.com/u/Itai_Peer)\ **Post date:** [June 30, 2024, 6:58am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/14 "2024-06-30T06:58:52Z")
If for example userA is the only one who has access to his 2 companies, this will have to be defined as a role? I have many users that each own 2-3 separate companies, more than 9 usersā€¦ That is a bit of a deal breaker for me, unless Iā€™m missing somethingā€¦? šŸ¤” ---
**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:** [June 30, 2024, 7:05am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/15 "2024-06-30T07:05:33Z")
Thatā€™s okay, you would use the Company Name (or Company ID) as a Role, and in the case where a user owns 3 companies then they would have 3 roles. As long as a user doesnā€™t own more than 9 companies then you should be fine. If that was the case, then you may need to get a bit creative and group companies together. ---
**Author:** ![Itai\_Peer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/itai_peer/32/75705_2.png) [@Itai\_Peer](https://community.glideapps.com/u/Itai_Peer)\ **Post date:** [June 30, 2024, 7:10am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/16 "2024-06-30T07:10:58Z")
Thanks Darren! I do have a few users that will need to have access to more than 9 companies. For example East region, West region account managersā€¦ How would I do that? ---
**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:** [June 30, 2024, 7:16am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/17 "2024-06-30T07:16:31Z")
Well like I said, you might need to get a bit creative. Perhaps you can group companies together - into regions? And then use the Region names as Roles/Row Owners. ---
**Author:** ![Itai\_Peer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/itai_peer/32/75705_2.png) [@Itai\_Peer](https://community.glideapps.com/u/Itai_Peer)\ **Post date:** [June 30, 2024, 7:18am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/18 "2024-06-30T07:18:51Z")
I see, So in that case I would have to dedicate one of the 9 roles to a region based role? ---
**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:** [June 30, 2024, 7:21am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/19 "2024-06-30T07:21:43Z")
For that user, yes. Keep in mind, the maximum is 9 roles per user, not 9 roles in total. You can have as many distinct roles as you want, but you cannot assign any more than 9 of those roles to any one user. To put it another way, when you define the array column in the Google sheet, the maximum number of columns that Glide will allow in the array is 9. ---
**Author:** ![Itai\_Peer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/itai_peer/32/75705_2.png) [@Itai\_Peer](https://community.glideapps.com/u/Itai_Peer)\ **Post date:** [June 30, 2024, 7:23am UTC](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453/20 "2024-06-30T07:23:00Z")
Ohā€¦ I see. That nailed it for me! haha Thanks so much Darren [Next page](https://community.glideapps.com/t/row-owners-groups-roles-and-relations/74453.md?page=2)