Display two columns in a reference field

[veena_kvkk88]

Hi everyone!

This community has been a huge help to me! Thank you everyone for that   Now I have a question. I was wondering if we could display two columns in a reference field. Not display them as suggestions, which can be done via adding attributes. Like, actually display two columns of the selected record, once the user makes his/her choice.

Eg: If a user selects "John Doe" for the Assigned to column, I want to display his phone number or email along with his name in the assigned to column.

Eg: Same goes with a list record. If user selects multiple users for a list field, i want name and phone number to be displayed in the field value.

Is this possible? How can I achieve it?

[Sashi K1]

how about creating a new column in the same table which stores Name and Phone number together. And make that column as Display value.

Thanks

[Abhinay Erra]

Veena,

  I do not think that is possible. Since we can only have one display value for the table

[Chuck Tomasi]

The only way I know to do what you suggest is to include those other fields as part of the name field (or other designated display value=true field). I have seen some customers include the employee ID in parenthesis to distinguish between employees with the same name. Keep in mind this happens for all instances of that reference field throughout the system so an address, phone, etc. could be rather ugly.

Doing this on a single field on a form is not supported outside of the search capabilities you already noted.

[Pradeep Sharma · Accepted solution]

HI Veena,

Unfortunately this is not supported. The other option is to pull other field from referenced table on form via dot-walking.

Dot-Walking - ServiceNow Wiki