Variable field duplicate check

SNOW39
Tera Expert

How can i check if the text entered in the variable which is a free field text is not repeated. Is there a table that store the value entered in variable of a catalog item.

10 REPLIES 10

SumanthDosapati
Mega Sage
Mega Sage

Where do you want to check if the value exists? With what do you want to compare if it's repeated

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

you want to check value entered in variable against what?

can you explain your business requirement here?

Regards
Ankur

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

SNOW39
Tera Expert

User 1 have a value entered.. say "test" and  submitted the form. Now again when user 2 raise a new request and enter value as "test" in the field, it should say that its a duplicate value.

If that is the case then instead of using catalog item, use record producer with any table and map the field to any of the field in that table.

Then you can write an onChange client script on that field and make an ajax call to check if that value is present in the table.

 

Mark as correct or helpful if it works.

Regards,

Sumanth