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.
Users: Name, email, company, projects, project submissions
Projects: Topic, start date, end date, submission details, related to users and project submissions
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!
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.