I started developing an app at the company I work for that displays the results of all employees based on some formulas and indicators. By selecting an employee's name, you can view their scores for each indicator, as well as their overall score. However, I have a question because I need to have two views in the app: one for supervisors/leadership, who can see the results of all employees from all teams, and one for team members, who can only see their own results.
I thought about creating a database with all users who have the "Admin" role, which will be for supervisors/leadership since changes to this database won't be very frequent. If a user is not in this database, they can only see their own results.
In this case, what would be a formula that makes sense for this structure? Or is there another way to achieve this?