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 