How to display the list from the table for reference field in service catalog?

2022_ServiceNow
Tera Expert

Hi,

 

I have created a table 'Meeting Type' with required options. I have given that table as a reference type in the catalog form with 'ref_ac_columns=u_meeting_type' as a variable attribute. But when I try it, it shows the options as 0,1,2,3,4. Why is it so?

How to display the options given in the table instead of those numbers?

 

Priya2399_0-1676552010093.png Priya2399_1-1676552121492.png

 

 

1 ACCEPTED SOLUTION

johnfeist
Mega Sage

Hi Priya,

The most common reason for seeing that setup is that you have a column in your table that has those numbers and that column is marked as display.  The system uses the column marked as display to pass a value that makes sense to us humans  rather than the sys id when displaying a reference.  Make sure that you have the descriptor that you need showing as display.  ALso make sure that yo uonly have one column marked as display.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

View solution in original post

2 REPLIES 2

johnfeist
Mega Sage

Hi Priya,

The most common reason for seeing that setup is that you have a column in your table that has those numbers and that column is marked as display.  The system uses the column marked as display to pass a value that makes sense to us humans  rather than the sys id when displaying a reference.  Make sure that you have the descriptor that you need showing as display.  ALso make sure that yo uonly have one column marked as display.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

Hi,

Thank you!