Create a Unique field with no duplicates

tsam
Kilo Explorer

‎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.

0 Helpfuls
  • 6,426 Views
8 REPLIES 8

CapaJC
ServiceNow Employee
ServiceNow Employee

‎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.


Martin Wood
ServiceNow Employee
ServiceNow Employee

‎11-12-2012 08:43 AM

Tick the unique field in the dictionary entry. 🙂


0 Helpfuls

CapaJC
ServiceNow Employee
ServiceNow Employee

‎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


0 Helpfuls

Priya Singh3
Kilo Contributor
In response to CapaJC

‎07-02-2021 02:54 AM

This link is incorrect