# Help with this relation for grouping **URL:** \ **Category:** Ask for Help\ **Created:** [August 14, 2024, 8:02am UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632 "2024-08-14T08:02:16Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![micheal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/micheal/32/80181_2.png) [@micheal](https://community.glideapps.com/u/micheal)\ **Post date:** [August 14, 2024, 8:02am UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/1 "2024-08-14T08:02:16Z")
Hello everyone, hope you’re all good. I’m working on an NGO kind of application specifically the membership side. What i need help with is relating them all together. Heres a scenario, there are three stages, HQ, Region and Branch. Each branch can only have access to its own data. A region can have two or more branches so it has data to each of it’s respective branch’s data and also it’s own unique data While HQ has access to the whole organization data and it’s own unique data. I can’t figure out how i would go about it would appreciate your help. ![2024-08-14 09_04_57-YWCA · Glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/02d3a7be82de82dc65f8f18b7c54d608a5d42bb7.png) ---
**Author:** ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)\ **Post date:** [August 14, 2024, 8:40am UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/2 "2024-08-14T08:40:13Z")
Hi Michael This is a perfect use case for row owners. In your user table, make sure you have a roles column set (in settings) to then in your regions table apply row owners. Don’t forget you can have more than one row owners column - so it’s common practice to add another text column in your groups table with the ID of any admins (or maybe HQ in your case) which gives super admins access to that row. So difficult to explain - happy to share an example with you if you wish? I have something very close to what you need I think. Andrew Just re-read your post. Is it just relations you need help with? ---
**Author:** ![micheal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/micheal/32/80181_2.png) [@micheal](https://community.glideapps.com/u/micheal)\ **Post date:** [August 14, 2024, 8:53am UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/3 "2024-08-14T08:53:12Z")
Hi Andrew… I already have row owners set in the email I don’t know how to use two row owners and I need help handing it out please. You can share what you have I’m very sure it would help me move really far. Thank you very much. 🙂 ---
**Author:** ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)\ **Post date:** [August 14, 2024, 9:10am UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/4 "2024-08-14T09:10:17Z")
Happy to! Can you DM me your email / Team ID and I will knock something up for you. Row Owners are very useful. Have you watched Robert Petittos excellent videos? [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/40c56070734f2e68e110eacb4e3edd9dc4379b01.jpeg "Glide 101: Row Owners vs. User Specific Columns") ](https://www.youtube.com/watch?v=sclFwC6eov8) ---
**Author:** ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)\ **Post date:** [August 14, 2024, 9:28am UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/5 "2024-08-14T09:28:10Z")
Take a look at these three screenshots. This MAY do what you need. Note which columns have row owners applied (with the little blue person icon in the header). When adding Rows - you need to make sure you have a special value or Set Column values - for these columns for Row Owners to work on future rows. It is not possible to use a calculated column as a Row Owner - it has to be a basic column. Hope this helps! Andrew ![Screenshot 2024-08-14 at 10.25.22](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/90617e21ee32d083bca7fd308e74f4c67c43645f.jpeg) ![Screenshot 2024-08-14 at 10.25.27](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/3/8348d41c8e7397735e21ad2f31b6585023e3e55e.jpeg) ![Screenshot 2024-08-14 at 10.25.35](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/6/86a5076726be7b9dea97236245d26baa5fe5a825.jpeg) ---
**Author:** ![micheal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/micheal/32/80181_2.png) [@micheal](https://community.glideapps.com/u/micheal)\ **Post date:** [August 14, 2024, 12:43pm UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/6 "2024-08-14T12:43:06Z")
wow i think this just might do it let me test it out. Also what does having multiple row owners do? I watched Roberts video but I still don’t get this part. ---
**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:** [August 14, 2024, 12:48pm UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/7 "2024-08-14T12:48:52Z")
> [@micheal](#): > > what does having multiple row owners do? It allows multiple people (if using email address) or multiple groups of people (if using Roles) to be owners of the row. If they are an owner, then they can access the data. ---
**Author:** ![micheal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/micheal/32/80181_2.png) [@micheal](https://community.glideapps.com/u/micheal)\ **Post date:** [August 14, 2024, 1:00pm UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/8 "2024-08-14T13:00:52Z")
that makes perfect sense. Thanks jeff ---
**Author:** ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)\ **Post date:** [August 14, 2024, 1:12pm UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/9 "2024-08-14T13:12:44Z")
Hi @micheal I made a simple app to demonstrate this - and added it to your team. Let me know how it looks! An example always helps ---
**Author:** ![micheal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/micheal/32/80181_2.png) [@micheal](https://community.glideapps.com/u/micheal)\ **Post date:** [August 14, 2024, 1:33pm UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/10 "2024-08-14T13:33:16Z")
It’s awesome I finally have a base to build up on. It works awesome I’ll get back to you on the app. Thank you. ---
**Author:** ![micheal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/micheal/32/80181_2.png) [@micheal](https://community.glideapps.com/u/micheal)\ **Post date:** [August 15, 2024, 2:11pm UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/11 "2024-08-15T14:11:55Z")
Hi andrew how are you today? thanks for yesterday. I tried to make an exact copy of your app but it dosent work as it should. At first i thought it was my account issue but then i logged into another account and it’s the same result. I attached the screenshot below I’m sure im making one minor issue but i cant seem to get it. Could you check it please. ![2024-08-15 15_08_27-YWCA · Glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/7/471815f9b3f6bd5c5c5adda9ffe0d1e02f807efe.png) ![2024-08-15 15_08_03-YWCA · Glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e84785d14e6deb840bcf37537cec02458ff688f6.png) ![2024-08-15 15_07_44-YWCA · Glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/f/efec1c7e32332084455cb02c20e17dbef4f74156.jpeg) ---
**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:** [August 15, 2024, 3:25pm UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/12 "2024-08-15T15:25:48Z")
The values in your owner columns do not match those in your Users table Role column. For example, you have Role values such as “President” and “Secretary” in your Users table, but completely different values in the other tables. ---
**Author:** ![micheal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/micheal/32/80181_2.png) [@micheal](https://community.glideapps.com/u/micheal)\ **Post date:** [August 15, 2024, 3:41pm UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/13 "2024-08-15T15:41:09Z")
ohh hi darren. The main column in the user table for this job is the Division column. The role is just the authority of the user. ---
**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:** [August 15, 2024, 3:50pm UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/14 "2024-08-15T15:50:50Z")
Okay, well what is important is which column you have set as the Role column in your User Profiles configuration: ![CleanShot 2024-08-15 at 23.48.30@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/20e019b1200d5157be53ca3ea80a0731886a4de0.png) The Role column can be any text column, and you can name it anything you want, but it is the _ONLY_ column that can contain text values to be used as Row Owners. ---
**Author:** ![micheal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/micheal/32/80181_2.png) [@micheal](https://community.glideapps.com/u/micheal)\ **Post date:** [August 15, 2024, 4:01pm UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/15 "2024-08-15T16:01:20Z")
wow that works… thank you so much. ---
**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:** [December 18, 2024, 6:48pm UTC](https://community.glideapps.com/t/help-with-this-relation-for-grouping/75632/16 "2024-12-18T18:48:07Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.