Create a Unique field with no duplicates
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-12-2012 07:14 AM
Hi -
I have created a form in SN and need to make one of my fields UNIQUE so there can be no duplicates. I am quite new to this and I have no idea where to start from.
Any pointers will be very much appreciated.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-12-2012 08:42 AM
Personalize Dictionary for that field. If the Unique checkbox is not on the Dictionary form, personalize the form layout for the Dictionary form and add it. Check it for your field, and update the Dictionary record.
Then a unique constraint will be enforced for that field. Note that the field must not have duplicate values already, or doing what I described will fail.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-12-2012 08:43 AM
Tick the unique field in the dictionary entry. 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-12-2012 09:02 AM
And here's some doc:
https://wiki.servicenow.com/index.php?title=Creating_New_Fields#Requiring_Unique_Values_for_a_Field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-02-2021 02:54 AM
This link is incorrect