Restrict Unique rows in MRVS

pramodkumar
Tera Expert

Hi All,

We have a MRVS on a catalog form. One variable in mrvs is "type" (select box) which has values A, B, C, D. we need to restrict one entry for type selected. User should  enter only one row for A, B, C, D. How can we achieve this?

 

 

Thanks!

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@pramodkumar 

check this checkbox under that variable within that MRVS

AnkurBawiskar_0-1738130464574.png

 

OR script based solution

check this link for solution

How to stop duplicates entering in MRVS based on MRVS Variables(Applies Catalog item/ServicePortal) 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

6 REPLIES 6

Ankur Bawiskar
Tera Patron
Tera Patron

@pramodkumar 

check this checkbox under that variable within that MRVS

AnkurBawiskar_0-1738130464574.png

 

OR script based solution

check this link for solution

How to stop duplicates entering in MRVS based on MRVS Variables(Applies Catalog item/ServicePortal) 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@pramodkumar 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ankur Bawiskar  When I tried to use unique on variable, it is working but the alert message cannot be customized. So I have tried the script, but it is not working. Do we need to have on submit script on MVRS or catalog form? I believe on submit client scripts will not work on MVRS

 

Thanks!

@pramodkumar 

Yes you will require onSubmit in that case if you wish to show customized message.

I believe I answered your original question on how to make it unique.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader