Display a different column on reference field

cgedney
Giga Guru

I am building a new catalog item. I have a reference field pulling from pm_project. I would like to display the Project Number in the field instead of the Project Description when the user selects it from the list.

find_real_file.png

find_real_file.png

I would like the Project number to be displayed instead of the Project description.

1 ACCEPTED SOLUTION

Harshinya1
Mega Guru

You can the change the display value by setting 'Display' attribute for your desired column to true.

table list view->configure->table-> go to columns

find_real_file.png

 

Hope this helps

View solution in original post

7 REPLIES 7

Harshinya1
Mega Guru

You can the change the display value by setting 'Display' attribute for your desired column to true.

table list view->configure->table-> go to columns

find_real_file.png

 

Hope this helps

Prateek kumar
Mega Sage

Which field is set the display attribute as true in the pm_project table??

https://YourInstanceName.service-now.com/nav_to.do?uri=%2Fsys_db_object.do%3Fsys_id%3Df89e6f81131012005261b4b2e144b0e1%26sysparm_record_target%3Dsys_db_object%26sysparm_record_row%3D8%26sysparm_record_rows%3D13%26sysparm_record_list%3Dsys_update_nameISNOTEMPTY%255ElabelSTARTSWITHproject%255EORDERBYDESCsys_updated_on

which field do you see when you navigate to the above URL?


Please mark my response as correct and helpful if it helped solved your question.
-Thanks

cgedney
Giga Guru

This is giving me an error (sys_id%3Df89e6f81131012005261b4b2e144b0e1). Dot wlak me to where you are trying to get me to and I'll post what I see.

Please take a look at this.

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/field-administration/task/t_SelectTheDisplayValue.html


Please mark my response as correct and helpful if it helped solved your question.
-Thanks