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

[win b]

@RaghavSh Because i need to select multiple serial numbers on one field. not just only 1

[RaghavSh]

@win b unfortunately, list collector can only show display value.

[win b]

@RaghavSh yes. thats why for now im trying to solve it also by using client script. and searching for answers also.

[RaghavSh]

So if you have to implement it anyway below is a solution:

1. Create a custom table with three fields alm_asset( reference) , location (reference) , serial number.

2. Load the data in that custom table and keep the display value as serial number. There will be multiple assets per serial number.

3. then create a variable in your catalog item (list collector ) and point it to your custom table.

Note: Every time an asset is created or serial number for any asset is created , you will have to update the custom table manually.

[win b]

@RaghavSh will try on this on the 4th method plan. my 2nd plan is using client script if it doesnt work. ill try the 3rd method which is mrvs but i dont know yet if MRVS would help me on this. upon creation of customize table may not be possible due to needed to approval first before implementing