# Link Users to Agency

**URL:** <https://community.glideapps.com/t/link-users-to-agency/71750>\
**Category:** Ask for Help\
**Created:** [March 17, 2024, 7:09pm UTC](https://community.glideapps.com/t/link-users-to-agency/71750 "2024-03-17T19:09:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paradize](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paradize/32/72367_2.png) [@Paradize](https://community.glideapps.com/u/Paradize)\
**Post date:** [March 17, 2024, 7:09pm UTC](https://community.glideapps.com/t/link-users-to-agency/71750/1 "2024-03-17T19:09:42Z")

</div>

Hey everybody,

I have an app for agencies to manage their clients.

This means, we have the following Roles:

App Admin  
App Member  
Agency  
Agency Admin  
Agency Member  
Agency Client

As you can see there are lots of different roles with different rules. I need to somehow come up with a good database management system, where I have a list of all app team members, all agencies, all agency team members and all clients.

I have a main users list in which I have one column with all roles. So far I have made the Email column the row owner and also thought about adding more row onwners, so that: 1. The agency can see all data from itself but also their team and clients. 2. We as the app team can view all user data.

How could I best go about this, also considering maybe using User IDs instead of emails, (thinking about the future, where we might incorporate change email function).

I have now temporarily solved this by adding a “Linked Email” and manually added the agency email to the corresponding users. (Email of the main agency account added to all users that are in relation to the agency) and then made that a row owner as well. But that is with emails and in case I change some minor things, this would probably mess up the whole app.

Thank you in advance 🙂

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 17, 2024, 8:36pm UTC](https://community.glideapps.com/t/link-users-to-agency/71750/2 "2024-03-17T20:36:51Z")

</div>

Have you looked into roles?

> [@🛡️Roles and Row Owners DEMYSTIFIED](https://community.glideapps.com/t/roles-and-row-owners-demystified/22956):
>
> wave Hey all, I meant to share this earlier today—I spent some time last night playing around with Row Owners and Roles (two Glide features I don’t often get the chance to use) and ended up learning quite a bit. The result? Another tutorial video for you all about how and when to use Row Owners and Roles, their benefits and limitations. Enjoy! [[Glide: Row Owners and Roles DEMYSTIFIED] ](https://www.youtube.com/watch?v=RmMLZINOwjQ) Wondering WHY you can’t assign row owners to a computed column (If then else, lookup, template…