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   

[ericjackson]

My initial thought is why do you need it to auto-populate or be on the form at all? Typically it's best practice not to have the user fill out anything you already know. Which I'm sure is why you're looking to populate the field, but if you have the info already why even show the field?

I would recommend using a script or something to simply look up and process the email address for use where you need it behind the scenes rather than showing the field and populating it.

[Terry Carter Jr]

Eric,

Thanks for your reply back to my question.  

Just to let you know I'm on the same page with you and I have said time and time again why do you want to populate something when all they could do is hover over the managers name and get the email address?  However, it is a requirement by the business to have it to populate on the form and I've tried to get around it with my use case of showing how you can get this information from the system but they will not budge.

[ericjackson]

So is the requirement to simply display the email address, as in read-only?

Sometimes if you can better figure out what the users are trying to accomplish you can suggest a better solution that they'll accept.

However, in order to better understand the requirement as you currently have it could you clarify the process you're looking at?

I presume it's something along the lines of the user selects the manager and then you need to display that manager's email address in another field. Is that field on the same page/form where they select the manager? Does it need to be used or displayed anywhere later in the process?

[Vivek Sridhar]

Hi Terry,

Is the requirement like, you have to populate the manager when a user is selected on the form?

Regards,

Vivek.S