I have an exclusive table called Inspections. I put two deck views for that table. One should appear only for user X and the other for user Y. But I want each user to see only the inspections that they themselves performed, each in their own display. How can I do this or would it not be possible?
Solved! Go to Solution.
For inspection table, add [Useremail] field, and capture the useremail address down there. This should be captured when the user create new inspection, so initial value is set to USEREMAIL() expression.
Then create slice with expression - [Useremail]=useremail()
User this slice to generate new view, where only the inspection performed by the login user will be displayed.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |