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]

Instead of using reference field, use lookup select box.

It should use the table as alm_asset only but in the Label and Value field, choose building. It will show you building.

Also there is a checkbox in lookup select box to show "unique value", check that and you will get only unique building names.

Please mark the answer correct/helpful accordingly.

[win b]

Hi @RaghavSh . i tried changing to select box and it works. but now im search on how can i get the serial number based on my location field. it only show me the name of the device but not the serial number itself. i used the list collector in order to get the serial numbers based on selected location

instead of name it should be serial number displaying

[RaghavSh]

You need to add another lookup select box with serial number as label and value, referring to alm_asset table.

In the advanced query of serial number pass:

javascript: 'serial_number='+current.variables.location;  // your location variable name

In variable attributes pass:

ref_qual_elememts = location ;  // the variable name you getting location.

Please mark the answer correct/helpful accordingly.

[win b]

in the serial number i all the serial number to be chosen not only 1 value. But i will the the advance in query in List collector if t would work