Create a Unique field with no duplicates

tsam
Kilo Explorer

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.

8 REPLIES 8

CapaJC
ServiceNow Employee
ServiceNow Employee

Wasn't incorrect 9 years ago 😉

https://docs.servicenow.com/bundle/quebec-platform-administration/page/administer/field-administration/task/t_RequiringUniqueValuesForAField.html

Priya Singh3
Kilo Contributor

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 ?

 

CapaJC
ServiceNow Employee
ServiceNow Employee

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.

Priya Singh3
Kilo Contributor

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.