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

shun6
Giga Sage

‎03-04-2024 02:52 AM

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

 

0 Helpfuls
  • 218 Views
2 REPLIES 2

Adrian Ubeda
Mega Sage
Mega Sage

‎03-04-2024 02:56 AM

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.

If it was helpful, please give positive feedback! ✔
☆ Community Rising Star 22, 23 & 24 ☆
0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron

‎03-04-2024 02:57 AM

HI @shun6 

 

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

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls