How to get the display name of reference field if using g_form.getReference

[Priyanka132]

Hi All,

I am using g_form.getReference to populate users details in a catalog item via client script. For a few fields in user profile like Business Unit, Department, cost center, I am getting the sys_id instead of the display value.

Since these fields are reference field , the value returned is sys id. How can i get the display value instead of the sys id.

var user= g_form.getReference('requested_for');
g_form.setValue('business_unit',user.u_business_unit.u_name);    ///business unit is a reference field on user table

I understand i can use asynchronous glide record in the client script to populate. but not sure if that is recommended

[Upender Kumar]

Hi

Please review

https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/field-administrat...

Thanks

[Upender Kumar]

Or

go to u_business_unit table and set display check checkbox fro name column.

Thanks 

[Priyanka132]

Hi Upender, thanks for your assistance. I would like to avoid making dictionary level changes in the custom tables. Is there any other way to achieve the requirement, preferably via catalog client script

[Upender Kumar]

Hi,

I have searched but not found any other solution.

Please share if you found solution other then setting display column.

Thanks