Populate user location using default value

Go to solution
nicolemccray
Tera Expert

‎08-30-2018 05:18 AM

I would like to auto-populate a 'Location' field based on the person selected in the 'New Hire' field.  Trying to do this using Default Value, but not working:

javascript:gs.getUser(current.variables.new_hire_name).getRecord().getValue('u_location');

 

0 Helpfuls
  • 4,925 Views
1 ACCEPTED SOLUTION

Go to solution
nicolemccray
Tera Expert
In response to Omkar Mone

‎09-05-2018 04:59 AM

I was able to get this working by changing the variable type to 'reference', and using the following code:

 

function onChange(control, oldValue, newValue, isLoading) {
 
 
 //Type appropriate comment here, and begin script below
  var newHire = g_form.getValue('new_hire_name');
    var user = new GlideRecord('sys_user');
    user.addQuery('sys_id', newHire);
    user.query(setLocation);
    function setLocation (user){
        if ( user.next() ){
            g_form.setValue('location_1', user.location);
            g_form.setValue('location_2', user.location);
        }
    }
}

View solution in original post

0 Helpfuls
15 REPLIES 15

Go to solution
Omkar Mone
Mega Sage

‎08-30-2018 05:24 AM

Hi 

Try this :- gs.getUser(current.variables.new_hire_name).getDisplayValue("location").

 

Mark correct if it helps.

 

Regards,

Omkar Mone

www.dxsherpa.com

 

Go to solution
Shashi Bhushan
Kilo Guru

‎08-30-2018 05:26 AM

javascript:gs.getUser(current.variables.new_hire_name).getRecord().getDisplayValue("u_location"); Please mark answer as correct or helpful. Thanks

0 Helpfuls

Go to solution
nicolemccray
Tera Expert

‎08-30-2018 05:41 AM

I was able to get a location to populate using this:

javascript:gs.getUser(current.variables.new_hire_name).getRecord().getDisplayValue('location');

 

But it is populating MY location, and not the location of the person in the 'new_hire_name' field.

0 Helpfuls

Go to solution
Omkar Mone
Mega Sage
In response to nicolemccray

‎08-30-2018 05:58 AM

hi 

So please tell me where are you doing this ?

0 Helpfuls