How to change field display value on a reference field.

Krishna Priya
Tera Contributor

‎08-16-2019 01:28 PM

 

On the catalog item form I have a reference field that points to 'location' table and field name is location.

When the user selects field Location Level is store. The display value of location field reference should store ID field not Name field. 

How can I make the display value on this form to display other fields in location table. At present i can select only Name field under location because it is target field.

 

If i select store it should show store id field on the form.

If i select District it should show District id field on the form. similarly for other field also.

 

Can anyone suggest?

 

Labels:
Preview file
13 KB
0 Helpfuls
  • 7,754 Views
1 REPLY 1

Brad Tilton
ServiceNow Employee
ServiceNow Employee

‎08-20-2019 11:49 AM

I'm not completely sure I'm following, but it sounds like on your location table for any particular location you have values on the record for store, district, region, and franchisee, and you want the display value on the location table shown in your reference variable to change based on another variable. 

You can't change the display value, but you can add more columns to the list of locations via the auto-complete: https://docs.servicenow.com/bundle/newyork-platform-administration/page/administer/field-administrat...

You could also write a client script that looks at the location level variable and then shows the appropriate display value from the location table as a field message under the variable.