Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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

shun6
Giga Sage
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
  • 297 Views
2 REPLIES 2

Adrian Ubeda
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