I am creating a time and attendance application. I used the template. The app will allow a contractor to add his employees and when they arrive at work, their time will be recorded. This works fine until I add another contractor. How do I restrict the contractors from seeing only their data.
I have a table call team with id, name, email columns… (the email column is the user who will login in)
I also have an employee table with empid, name, company
I followed the documentation and tried this filter.
IN(Employees [Company], SELECT(Team [Id], [emailaddress] = USEREMAIL()))
What I am trying to do is to for the user that is logged in to see only the employees that are in his company.
I must mention that as a ref it is working from the teams view. I want to filter the employees view.