Reference table

[sampathkade]

I created custom field that points to a Custom reference table(which I created)its value showing created on instead of user names when i select the field from custom reference table.

For Example: In incident form if we take caller field when we select record from user table which points to a caller field it shows users in the caller field (Abel tuter, Fred Luddy.....etc) but in my case the field value which i created showing created on.

How Can I over come this ?

[Kieran Anson]

Hi,

You'll need to update the display column for your table to the field you wish:

https://www.servicenow.com/docs/bundle/xanadu-platform-administration/page/administer/field-administ...

[Voona Rohila]

Hi @sampathkade 

• For the custom table, make sure you set the name field display to true.

Refer this link for steps -  How to set name as the table display value

• Also, Update the reference list layout for the custom table to show name field and few other fields if required( this is the layout that opens when user clicks on reference icon also known as popup view)

Refer below link for steps: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0686318

[Yaramala]

Hello @sampathkade 

To change the fields of reference table you can refer to this page: Link

If this addresses your question, please mark this response as Accepted Solution and/or give it a Kudos if you find it helpful.

Thank you!

[Selva Arun]

Hi,

It looks like others have already provided great insights!

To set a field as the display value in a table:

1. Navigate to Dictionary: Go to All > System Definition > Dictionary and filter by the referenced table name.
2. Select the Field: Find the desired field and set the Display property to true.
3. Best Practice: Choose a required and unique field as the display value for optimal results.

Key Notes:

• Only one field can be the display value for a table.
• If you're working with an extended table, the child table inherits the display value from the parent, but you can override it for the child table.
• Ensure the field is translated in all required languages, as untranslated fields will not appear in the autocomplete feature.

Reference Field Lookup:

• The system looks for a field with display=true first in the lowest sub-table (for extended tables), then in the parent table, and finally checks fields named name, number, or other custom field names like u_name or u_number.

This will ensure that the field you want is used as the display value when selecting records in reference fields.

Select a field as the table display value

If you believe the solution provided has adequately addressed your query, could you please **mark it as 'Helpful'** and **'Accept it as a Solution'**? This will help other community members who might have the same question find the answer more easily.

Thank you for your consideration.

Selva Arun