Changing the display value from First Name Last Name to Display Name

[Carl Murray]

We are trying to understand how we can do one of 2 things in ServiceNow -

Change the value displaying for our sys_user table when pulling it through a Reference field in the Service Catalog to either:

The Display Name pulled from LDAP

First Name Initials Last Name

I have read the articles on reference fields, but I am not understanding currently how to accomplish this change.

[Pradeep Sharma]

Hello Carl,

Only one field can be defined as the display value for a given table. Please refer below link section 3.1 for more info on how to set the display value. Please note this will be a global change and will be applied to all the fields referenced to the "sys_user" table.

http://wiki.servicenow.com/index.php?title=Reference_Fields#Selecting_the_Display_Value&gsc.tab=0

However, you can define auto complete for reference fields. Please go through the below link and check if this fulfills your req.

http://wiki.servicenow.com/index.php?title=Auto-Complete_for_Reference_Fields#gsc.tab=0

Please let me know if you have any questions.

[darius_koohmare · Accepted solution]

You can choose what field is being used in the terms of the display value field on the dictionary entry of the column.

Right click the field you want to become the display value, and set the display true/false field to true.

This will cause all reference fields for that given table (e.g. sys_user) to display as that field.

[darius_koohmare]

ServiceNow Express: Dictionary Fields & Attributes - YouTube   5:38 forward covers this concept.

[TrenaFritsche]

Hello,

I'm wondering about a display value override for specific tables, but dictionary overrides related list doesn't seem to show?  For example, we have the user_name field on the "sys_user" table (which is basically the UserID and not always the name) and have added variables or fields to show the "name" on various forms where we have them referencing the sys_user table.  We cannot change the Display Value on this table because we have so much built (10 years of work) where the User ID and User Name both display.  As we are implementing new products (ie: PPM), these customers are wanting to stay mostly OOB and not change various PPM forms that have sys_user referencing fields that can type the person's name in the field and autocomplete finds it (that feature is configured), but once it is selected, the display value is the User ID and not the name as the PPM customers want it to display.  In order to give them the field that displays the name, we would have to add a custom field to the form.  I know the reference icon can show the name if they hover over it, but I'm trying to allow this display value override on this table, but I'm guessing it is not available due to it being a foundation type table?  Not sure, but it anyone can help me understand the reasoning or if I'm maybe missing something where it is able to be done, that would be awesome if you can share.

Thanks in advance for your assistance!

Trena Fritsche