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
‎07-02-2021 08:17 AM
Wasn't incorrect 9 years ago 😉
https://docs.servicenow.com/bundle/quebec-platform-administration/page/administer/field-administration/task/t_RequiringUniqueValuesForAField.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-02-2021 02:42 AM
Hi I have same requirement where I have created 1 variable named as Name on a SR form, and I want to make it unique so that it could not be conflict with existing records. I tried to take Unique checkbox by form designer however it's not showing on variable form (Single Line Text).
Please suggest how can I achieve this requirement ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-02-2021 08:18 AM
The existing capability for uniqueness only applies to table columns. It does not apply to variables. I don't think there's an accommodation for that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-03-2021 09:01 AM
Thank You link is opening now however it's not applicable on Variables to make unique as you said.
I am new into Service Now Could you please assist if I can achieve this functionality with the help of client scripting or what code I need to type so that it didn't accept name which is already available in cmdb_ci table.