Current user
I have an app to schedule vacation requests. The user logging in should only be able to see vacation requests of his own or his subordinates ( so He can approve requests) How can I restrict the vie...
Forum Discussion
I have one table called corporate directory; it lists the employees and their supervisors. I created a many to many within corporate directory to pull supervisor data see below
------------------------------
Rhonda Parriet
------------------------------
------------------------------
Rhonda Parriet
------------------------------
------------------------------
Rhonda Parriet
------------------------------
- MarkShnier__You
Qrew Legend
That looks like a good app design.
You can lookup the Supervisor userid down to the vacation request. Then set the Custom permissions for View and Edit where
any
[Employee user] is the current user
[Supervisor userid] is the current user
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
