# Creating Custom Views **URL:** \ **Category:** Get Help\ **Created:** [May 2, 2023, 3:43am UTC](https://forum.adalo.com/t/creating-custom-views/38603 "2023-05-02T03:43:05Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![jacfulton](https://avatars.discourse-cdn.com/v4/letter/j/3e96dc/32.png) [@jacfulton](https://forum.adalo.com/u/jacfulton)\ **Post date:** [May 2, 2023, 3:43am UTC](https://forum.adalo.com/t/creating-custom-views/38603/1 "2023-05-02T03:43:05Z")
Hi team, I’m struggling to create a view for users depending on their organization. I’ll try to explain. I have an Admin with associated users. Admins create projects for users to submit work to. I only want users to see the projects created by their admin. I want to test my app with multiple businesses, but right now everyone can see every single project. I’ve figured out how to filter users so Admins only see their users, but don’t know how to set up a rule for the projects. Essentially i only want users to see the projects their admin created, but do not see where I can do that. Current databases: Users: Name, email, company, projects, project submissions Projects: Topic, start date, end date, submission details, related to users and project submissions All suggestions welcome! Thanks for your help! ---
**Author:** ![theadaloguy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/theadaloguy/32/8023_2.png) [@theadaloguy](https://forum.adalo.com/u/theadaloguy)\ **Post date:** [May 2, 2023, 3:49am UTC](https://forum.adalo.com/t/creating-custom-views/38603/2 "2023-05-02T03:49:18Z")
You need a relationship between users and admin. Then you can filter the list of projects to be “logged in user \> admin \> projects”. ---
**Author:** ![jacfulton](https://avatars.discourse-cdn.com/v4/letter/j/3e96dc/32.png) [@jacfulton](https://forum.adalo.com/u/jacfulton)\ **Post date:** [May 2, 2023, 4:02am UTC](https://forum.adalo.com/t/creating-custom-views/38603/3 "2023-05-02T04:02:08Z")
Right now I have a True/False field for admin under users - all in the same database. So instead I should have separate databases for Users and Admins, with the relationship between the two …that makes sense. Thanks, I’ll give that a try! ---
**Author:** ![theadaloguy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/theadaloguy/32/8023_2.png) [@theadaloguy](https://forum.adalo.com/u/theadaloguy)\ **Post date:** [May 2, 2023, 4:20am UTC](https://forum.adalo.com/t/creating-custom-views/38603/4 "2023-05-02T04:20:43Z")
It doesn’t need to be a separate database either, you could still maintain types of user with the admin true/false, and then have the relationship between User and User. Just make sure to rename the relationships or it will be confusing. ---
**Author:** ![jacfulton](https://avatars.discourse-cdn.com/v4/letter/j/3e96dc/32.png) [@jacfulton](https://forum.adalo.com/u/jacfulton)\ **Post date:** [May 10, 2023, 3:28am UTC](https://forum.adalo.com/t/creating-custom-views/38603/5 "2023-05-10T03:28:42Z")
I think I’ve got it! What if i want to have more than one admin on a team. Can i still do that with one database? Do i need another column to identify being grouped i.e. by company or department? ---
**Author:** ![theadaloguy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/theadaloguy/32/8023_2.png) [@theadaloguy](https://forum.adalo.com/u/theadaloguy)\ **Post date:** [May 10, 2023, 3:43am UTC](https://forum.adalo.com/t/creating-custom-views/38603/6 "2023-05-10T03:43:04Z")
Just make sure it’s the correct type of relationship. If a user could be admin of multiple companies, have a many to many relationship. If you think each user could only be admin to one company, have a many to one relationship where ‘a company can have many users, a user can only have one company’. Either way, a company can have multiple admins. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\ **Post date:** [May 20, 2023, 3:44am UTC](https://forum.adalo.com/t/creating-custom-views/38603/7 "2023-05-20T03:44:01Z")
Closed on May 20, 2023, 3:44am UTC This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.