How to show unique values on a reference field

Alon Grod
Tera Expert

I have the field 'site' type reference to u_sites table on the incident table. In u_sites table i have two columns:
1) site name (display = true)
2) site location

In this table i have multiple sites with the same name but with a difference location.

When the user search for a site from the incident table, he see the same site name multiple times, for example:
Alon
Alon
Alon

How can I make sure that he will only see unique names (Alon will appear only once even though each 'site name' has a different location)

2 REPLIES 2

pratiksha5
Mega Sage

Try this : https://www.youtube.com/watch?v=-FFs0mIJM_Q

 

Please mark helpful if it helps. 

 

Get Organized: A Tutorial on How to Display Two Columns in Your Reference Field Like a Pro Hi All, Hope you are doing great. In todays tutorial we wlil be looking into ServiceNow Reference field . We will be working on the use case to see how to display two column in a reference field Before ...

Anurag Tripathi
Mega Patron
Mega Patron

Check this thread, similar post is answered here.

Solved: How to display only unique values from the Referen... - ServiceNow Community

-Anurag