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.
Solved! Go to Solution.
Please check this sample app how itโs done called โHorizontal Scaleโ from www.appsheet.com/portfolio/531778
User | Count |
---|---|
43 | |
28 | |
24 | |
21 | |
13 |