auto populate current user and its location

sp_18 · ‎04-24-2018

Hi,

i have this catalog item with variables-

I want auto populate the Applicant's Name field with logged in user and auto populate the location field of the current user with onload action.

what will be the onload client script?

Thank you.

sashichand · ‎04-24-2018

Hi,

To auto populate the Applicant's Name field with logged in user - While defining the variable, set the default value as javascript:gs.getUserID(); ------- This will give you the current logged in user.

To auto populate the location field of the current user with onload action.

write an onLoad script:

var id = g_form.getValue('applicant_name'); //variable name
var user = new GlideRecord('sys_user');
user.addQuery('sys_id',id);
user.query();
if ( user.next() ) {
g_form.setValue('location', user.location);

g_form.getValue('requestor_manager', user.manager);
g_form.setValue('phone', user.mobile_phone); //to set the phone number.
g_form.setValue('emp_number', user.employee_number); // to set the employee number.

}

Hope this will be helpful?

Thanks,

Shashikant

View solution in original post

apjohn2 · ‎10-18-2018

johannesgrosbøll that worked for me and it's so much cleaner - thank you!

Ronak3 · ‎11-09-2018

Hi Johan,

I tried to implement the same default value but not able to get the value auto populated. my reference table for location variable is "cmn_location" and i even tried with "sys_user" reference. Could you please suggest. Thank you!

sashichand · ‎11-14-2018

Try JavaScript:gs.getLocation();

jennyjenny · ‎04-09-2019

Hi ,

I have used the same code but am getting sys_id of the manager as shown below

please help me on this.

Thanks,

Jenny

JohannesGP · ‎04-10-2019

Hi Jenny,

Is your "Line Manager Approval" field of the type String or Reference? It should be Reference, pointing to the cmn_location table.