Reference Field That remove duplicates & getting value of building.

[win b]

Hi can you help me on this task. The key on the task is to use a table (alm_asset) wherein im going to use the Reference as Type to get the value of building in the alm_asset table. But the needed requirements is dropdown should only show the building names and no duplicate entries in choices.

in the advance qualifier i want to get only the values of he building field but i failed to get it.

here is what i want to get but in my dropdown it only shows the name of device

also if its possible upon selecting the location i can retrieve the serial numbers of the selected location on another field?

[win b · Accepted solution]

@RaghavSh I got an update on this. I completely done this using MRVS here is what i did. 
In my MRVS i inserted my Building Location and Asset Serial Number and both of them using Lookup SelecBox. unfortunately when it comes on Variable Set OnSubmit Catalog Client Script im having error on JSON.parse. But on my OnSubmit Catalog Item its currently fine.

here is my code in Variable Set OnSubmit that have an error. Which supposed to be checker upon adding rows in MRVS forbidding to Add a duplicate entry 

But on my Catalog Item OnSubmit its already working. 

i needed help on the Variable Set OnSubmit only for now for avoiding adding duplicate

[RaghavSh]

No, list collector and reference fields cannot show anuthing except the display value of table.

Like for user table it shows only username.

Please mark the answer correct/helpful accordingly.

[win b]

@RaghavSh I found a solution. but still not yet kind of clear. when i go to the table of the alm_asset i found out that the serial_number Display is false. and i set it to true. so right now i need to find only a solution on how can i display false on this using the variable attributes.

[RaghavSh]

That is the point we should not set serial number as display true in OOB system table, that is a platform level change. The consequence of doing this is that wherever in the platform you are using alm_asset table , the reference and list collector fields will start showing serial number instead of name. Which is not a good experience and can break at multiple places.

I would not recommend this and will recommend to revert this change ASAP.

[win b]

Ok i see. But can i customize the dropdown on List Collector choices which i needed to display only the serial number instead of display name? Using Client Script?

[RaghavSh]

Why do you want list collector, why not a single line text or lookup selectbox to show serial number based on location.

With LC and reference field, you will not be able to achieve this.