Quick scenario rundown: We have an Employee Off-boarding workflow I put together. Our process is to set the Requester as the person's manager. One of the fields in the form is for their Employee Email, which HR inputs when they fill out the form.
Here's what I'm trying to do. Since the Employee Email is in the ticket form, I need to set up a trigger to use the email address to search for the user profile and pull back the user's Profile ID. It then needs to put the Profile ID and copy it into another dedicate custom field I have. This field will be hidden and used to update user profile fields, such as which buildings they have access to, whether they're VIP, etc.
Any advice or direction would be extremely appreciated.
Thanks!