Auto-populate fields from selected user

Bhadley · ‎07-02-2014

Hi all,

A bit of a beginner when it comes to javascript so I was hoping someone may have a recommendation for me. I've also found various tidbits of information out in the wiki on field auto-populating on forms but couldnt figure out how to piece the information together to make a workable code.

I have a form in the service catalog for employee changes. The first field in the form is a reference field to sys_user so that a user can be chosen that will need the changes. Below that I have reference fields for the old information such as department, manager, etc. What I would like to accomplish is that based on the user chosen in the field it will auto populate the rest of the fields with their current information. In the past we have used similar bits of code such as below on each variable to auto populate fields but gs.getUserID grabs the user filling out the form.

javascript:var id = gs.getUserID();

var user = new GlideRecord('sys_user');

user.addQuery("sys_id", id);

user.query();

var rc = "";

if (user.next())

rc = user.manager;

rc;

I am guessing I may need to do a Catalog Client Script using onCellEdit or onLoad? But I cant seem to find the correct setup of script to pull the information based on the Reference Lookup sys_user variable of name. Any help or guidance would be much appreciated, thanks!

justin_drysdale · ‎07-02-2014

You are on the right track!

Use an onChange catalog client script. It should work for your needs.

var id = gs.getUserID(); is only going to give you the person that is using the form. This person may or may not be the same as the person who is in the first field... so it is better to get the value of the first field instead.

"I have a form in the service catalog for employee changes. The first field in the form is a reference field to sys_user so that a user can be chosen that will need the changes"

Try this:

function onChange(control, oldValue, newValue, isLoading) {


var id = g_form.getValue('u_first_field');//replace 'u_first_field' with the name of your reference field.


var user = new GlideRecord('sys_user');


           user.addQuery('sys_id',id);


           user.query();


if ( user.next() ) {


   g_form.setValue('u_manager_field', user.manager);


   g_form.setValue('u_last_name', user.last_name);


   g_form.setValue('u_whatever', user.field_on_sys_user);


}


}

For the onChange script variable, choose the user reference field ( the first field on the form ).

View solution in original post

Nestor Padilla1 · ‎07-10-2020

Can you provide an example of what you mean?

SWAPNIL KULKARN · ‎06-19-2022

correct sir...can you please help for code of script include and client script in this case using glideajax, it will be really. helpful

skm1 · ‎06-09-2016

Thank You.. Helped me a lot.

ewereer · ‎05-09-2017

Hi ,

I have a issue. I need to populate a reference field based on the location of the logged-in user.

ex- if the logged-in user is from X country ,the fulfillment group should populate Y.

and if logged-in user is from A country, the fulfillment group should populate B.

Thanks.

Shishir Srivast · ‎05-10-2017

Hi Anup,

You can create a Assignment Lookup to populate the data based upon the user's location.

Assignment lookup rules example

http://wiki.servicenow.com/index.php?title=Defining_Assignment_Rules