How to change field display value on a reference field.

[Michael M1]

On the Change Request form I have a reference field that points to 'cab_meeting' table.

When the user selects this field a list of upcoming cab meetings are displayed. They are displayed by name with start date as an additional column. When the user selects the meeting the field just shows 'CAB Tuesday meeting' but I want it to show the 'start' column (e.g. 23-Nov-2018). 

How can I make the display value on this form be start date without changing the display value for the table in general. 

I have a similar request for a user to choose a country from the cmn_location table but without changing display value on that table as well.

Thanks for the help.

[Pradeep Sharma]

Hi Michael,

You can only have one display value for a Table. That said you can specify the list of reference table columns to display with attribute (ref_ac_columns). However, if your requirement is to show a different field as a display value after the form is saved then you have to two options 1) To create a custom field and populate it via script. 2)Select field on reference Tables using dot-walking.

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

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

Please let me know if you have any questions.

Thanks,

Pradeep Sharma

[Michael M1]

Thanks. How do I do the 2nd one in my example? If I provide a list of meetings, how do I dot walk to 'start' on the reference field displayed?

[Pradeep Sharma]

Hi Michael,

Please refer to below link on more info on dot-walking.

https://docs.servicenow.com/bundle/london-platform-user-interface/page/use/navigation/concept/dot-walking-examples.html

Thanks,

Pradeep Sharma

[Pradeep Sharma]

Hi Michael,

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

-Pradeep Sharma