Select the column in the reference type variable

jkelvynsant · 3 weeks ago

Hello community, I have a reference variable that by default displays the "Name" column. I would like it to display the "u_managed_by" column only in that case. I applied this code:

But the visualization is like this:

Huynh Loc · 3 weeks ago

Hi @jkelvynsant ,

For a single-selection Reference field, the "display column" value is the designated display value of the referenced table and cannot be hidden via standard variable attributes in the Service Catalog. Workaround: Use a Lookup Select Box

Instead of a Reference field variable, use a Lookup Select Box variable type.
This allows you to choose which field from the referenced table is used as the display value, giving you more control over what is shown to the

View solution in original post

Ankur Bawiskar · 3 weeks ago

@jkelvynsant

Did you get a chance to check above response?

Regards,
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader

Deepak Shaerma · 3 weeks ago

hi @jkelvynsant

Just update your attribute to :

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_managed_by,ref_ac_display_value=false

Happy to help! ‌‌
To help others in the community find this solution, kindly mark this response as the Correct Answer ‌‌ and Helpful‌‌.
Warm Regards,
Deepak Sharma
Community Rising Star 2025