We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

How to show different values in reference field for different tables

dharmesh rathod
Tera Contributor

Hello All,

 

I have a custom table 'u_sla_service_configuration' which has two fields of type string 

1. CMDB Level of service (value to be displayed in cmdb_ci table) (Note: Display:true)

2. Catalog item level of service (value to be displayed in sc_cat_item table)

 

There is one custom field of type reference created on both cmdb_ci and sc_cat_item table

Field name: Level of service

Reference table: u_sla_service_configuration

 

I have added respective reference qualifier on the field 'Level of service' to show data as per condition CMDB on cmdb_ci table and Catalog on sc_cat_item table each

 

Now my requirement is: 

I want to show value of 'CMDB Level of service' field on 'cmdb_ci' table like below

dharmeshrathod_0-1724150226760.png

 

 

and Value of 'Catalog item level of service' on sc_cat_item' table

But due to Display: true is set for 'CMDB Level of service' field I m getting blank value on sc_cat_item table 'Level of service' field

dharmeshrathod_1-1724150489488.png

 

 

How can i overcome this challenge?

Note: I m aware that two fields display true cannot be set. Is there any other alternative workaround to achieve this  requirement?

5 REPLIES 5

The field type doesn't matter. The question is IF you can dotwalk or not. I don't know the setup so I don't know if you can.

MarkManders_0-1724158031157.png

I dot walked to the string field 'street' on the user form in the above screenshot.
If you can't dot walk, you will need to script the result into your field. A table can only have one display field.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark