Variable field duplicate check
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-28-2022 02:40 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-28-2022 02:52 AM
Where do you want to check if the value exists? With what do you want to compare if it's repeated
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-28-2022 02:56 AM
Hi,
you want to check value entered in variable against what?
can you explain your business requirement here?
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-28-2022 03:03 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-28-2022 03:15 AM
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