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

cgedney
Giga Guru

That makes sense that they force only one field to be displayed.

When I go to that table, the Number field is the one set to true. But when I add that field to a form, the description is displayed.

The other weird thing is when I go to my developer instance, the Number and Description fields are set to true.

So there has to be an override to allow me to display, for this drop-down only, the Number field instead of the description field?

 

You need to override dictionary of TAsk  table for number column on pm_project table  to resolve this issue.

 

- Navigate to dictionary override of short description column for pm_project table and make "override display value" to false like below

 

find_real_file.png

 

- Navigate to dictionary override for number column for pm_project table and make override display value to true like below

 

 

find_real_file.png

 

Regards,

Sachin

cgedney
Giga Guru

That would have been what I would want to do. However, that affects all reference fields that use the pm_project table. I only wanted it on this one field.