Let me describe the scenario:
(1) A business has multiple locations
(2) Each location has an administrator. Some administrators are assigned to multiple locations.
(3) Each location administrator is responsible for scheduling interviews for new hires at the locations they are responsible for.
I am trying to set up a sheet and process where location administrators can schedule interviews for candidates at one of their locations, who will be interviewing with employees who work at that location.
The sheet will list all of the relevant information (office, candidate, interviewee, evaluation, etc.). The interviewers will be notified when an interview is scheduled and can complete the evaluation of each candidate, using Dynamic View, so the interviewers are limited to the records assigned to them as interviewers. The location administrators will be notified when an evaluation is complete and can take further action on the records for which they are the administrators.
Here is where I am stuck: When an administrator completes a form to create a new interview, I want to limit the locations available for the administrator to pick from to the locations for which they are the administrator. Therefore, if there are 50 locations and the administrator is assigned to 3 locations, they can only choose from those 3. I can create a lookup table that associates each administrator with their offices, if that helps.
