I have a request to build an approval process on a custom object and the request should be routed to the "Director" (ie, the record owner's manager's manager), and it appears the way to accomplish this is with a trigger.
From what I've read, this is what I think I need:
I need to create a 'Director' field on the User object that will populate the manager of the user's manager to reference for the approval.
On the User object, the trigger should fire whenever the Manager != NULL or if the user's manager is changed and update the Director field.
How can I implement this requirement?