Auto-populate the manager's e-mail address

[Terry Carter Jr]

Hello All,

I am trying to find a easy and good solution to populate the manager's email address of a user from the sys_user table in a custom variable field for a service catalog item.  The name of the variable field is "mgr_email" and I want to pull the manager's e-mail address in this field.  I am currently working on an order guide for Onboarding/Offboarding so this is one of the business requirements on the catalog items attached to it.    

I have tried various solutions on the community but none seem to work properly or there are so many examples that it overwhelms you to which one should be the right answer.

Any help or assistance would greatly be appreciated. 

Thanks,

Terry   

[Archana Reddy2]

When you are filling New Team Member Name (above snapshot), you want the manager's email to be filled. Am I right? 

[Terry Carter Jr]

Yes I want that user "New Team Member Name" manager to be populated in the "Manager's Email" field listed.

[Archana Reddy2 · Accepted solution]

Then, select "New Team Member Name"  at the highlighted area.

[Terry Carter Jr]

Archana,

Yes that worked!  You are a life saver!  

I'm now getting the manager's email address on the form now.

I owe you one once I get my scripting level to yours.  LOL 🙂

[Archana Reddy2]

Finally..!!!

Glad to hear that 🙂