I am using the timesheet template. Several Contractors are working in the application. A signed in contractor via their email address can see only the records of their employees. This works fine.
I was asked to allow another user for the same contractor’s company to see the company’s data but as read only. How do i get different email addresses to link to a company and see its records?
Tables:
Team, -TeamId, Company, email
employees, - Empid, Name, TeamID, status
appuser, - AppuserID, Name, Company, Email, Role
roles - RoleID, Role
I want to filter the timesheet records by TeamID, based on useremail
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |