I have two different lists that I am working with:
- Employee Out
The Directory has all the up-to-date information pertaining to each employee as far as name, team, email, and phone number. The employee out list is just as it sounds, just documenting when an employee is out.
I would the like the employee out list form to have some automation in some capacity. When I go to type in the name of an employee in the employee out list, I would like the team field to be populated by grabbing that information from the directory.
What are my options with this?