question How to add only unique value in a field in Community Central forum

How to add only unique value in a field

Gopal14 — Thu, 22 Aug 2024 06:14:38 GMT

Hi Team,

How to add only unique value in a field.

In cmdb_hardware_product_model table I have a field called Barcode, In this field I want add a value, same value If I am trying to enter in any another record in model table, it needs to through an error.

EX: I am having 10 records in model table, In one record I have entered Hopeforthebest in Barcode field. If I enter same value in remaining 9 records, then It should show an error message.

How can we achieve this

Re: How to add only unique value in a field

Murthy Ch — Thu, 22 Aug 2024 06:21:13 GMT

Hello @Gopal14

You can make utilize the UNIQUE featue for that particular field and change the value to "true"

Before doing that you need to remove duplicate information if exists.

Hope it helps:)

Re: How to add only unique value in a field

vishakhayadav24 — Thu, 22 Aug 2024 06:30:01 GMT

Hi @Gopal14

You can achieve this by two ways-

on dictionary you can set it as unique true.

or another way is writing a BR before insert/update - check barcode value is existing in any record if yes then abort the action and show error message.

Thank you!!!

Vishakha Yadav