Add multiple fields that references same table and record but display differrent field value

[shun6]

Hi all,

I add User Company field(references sys_user) on User Role[sys_user_has_role] table.

User role already have User field which references Use[sys_user] table.

In this case Is it possible to display differrent field value on each field ?

ex.) both fields references same record but User field display user's name, User Company display user's company

[Adrian Ubeda]

Hello @shun6 ,

Only one field can be the display value of one table. I'm afraid with reference field you are not going to be able to do that.

https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/field-admini...

Yo can create a custom field and the show what you need, but should be something out from OOTB.

[Dr Atul G- LNG]

HI @shun6 

try to do dotwalk to company for 1 field and for another user name.