Reference Field That remove duplicates & getting value of building.

win b
Mega Guru

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.

winb_0-1669614026175.png

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

winb_1-1669614240816.png

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

winb_2-1669614294933.png


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

 

2 ACCEPTED SOLUTIONS

@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.

winb_1-1669946062108.pngwinb_2-1669946087699.png

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 

winb_3-1669946189812.png



But on my Catalog Item OnSubmit its already working. 

winb_4-1669946295511.pngwinb_5-1669946301617.png

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

View solution in original post

22 REPLIES 22

@win b with MRVS or any other field you can show the serial numbers but you cannot select them. showing is not a problem, I can provide that script.


Raghav
MVP 2023
LinkedIn

@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.

winb_1-1669946062108.pngwinb_2-1669946087699.png

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 

winb_3-1669946189812.png



But on my Catalog Item OnSubmit its already working. 

winb_4-1669946295511.pngwinb_5-1669946301617.png

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

Refer : https://www.servicenow.com/community/it-service-management-forum/multi-row-variable-set-check-for-du... 

 

It will not allow you to enter duplicate one.


Raghav
MVP 2023
LinkedIn