Catalog Item getting SYS ID instead of their actual item name

[Peter Williams]

Good Day everyone,

i created a catalog item that is used for internal changes to an employee.

In my form i have a reference field linked to the sys_user table and when you choose a person their information will get populated into single text fields via a client script.

What is happening, the person Manager (linked to the sys_user table) and their Location(linked to the cmn_location table) is only coming back with the Sys_ID as seen below:

The script i am using is the following:

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

   if (isLoading || newValue == '') {

      return;

   }

   var userDetails = g_form.getReference('preferred_name', myFunc);

   function myFunc(userDetails){

    g_form.setValue('current_title', userDetails.title);

    g_form.setValue('current_persona', userDetails.u_persona);

    g_form.setValue('current_share_team', userDetails.u_share_team);

    g_form.setValue('current_department', userDetails.department);

    g_form.setValue('current_office_workstation_id', userDetails.u_desk_location);

    g_form.setValue('current_location', userDetails.location);

    g_form.setValue('current_phone_number', userDetails.phone);

    g_form.setValue('current_manager', userDetails.manager);

   }

}

how can i modify the manager and location field to read the Name instead of the sys_id?

[Peter Williams · Accepted solution]

I was able to figure it out,

here is the updated code for anyone to use.....

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

   if (isLoading || newValue == '') {

      return;

   }

   var userDetails = g_form.getReference('preferred_name', myFunc);

   function myFunc(userDetails){

    var locInfo = new GlideRecord('cmn_location');

    locInfo.get(userDetails.location);

    var userInfo= new GlideRecord('sys_user');

    userInfo.get(userDetails.manager);

    g_form.setValue('current_title', userDetails.title);

    g_form.setValue('current_persona', userDetails.u_persona);

    g_form.setValue('current_share_team', userDetails.u_share_team);

    g_form.setValue('current_department', userDetails.department);

    g_form.setValue('current_office_workstation_id', userDetails.u_desk_location);

    g_form.setValue('current_location', locInfo.name);

    g_form.setValue('current_phone_number', userDetails.phone);

    g_form.setValue('current_manager', userInfo.u_preferred_name);

   }

}

[Peter Bodelier]

You need to set both DisplayValue as Value

[Peter Williams]

where in the code ?

[Peter Bodelier]

    g_form.setValue('current_location', userDetails.location);
    g_form.setDisplayValue('current_location', <<location display>>);
    g_form.setValue('current_manager', userDetails.manager);
    g_form.setDisplayValue('current_manager', <<manager display>>);

[Peter Williams]

Sorry this didnt work