use below script in on before BR on Insert

   var target = new GlideRecord('cmn_location');

       target.addQuery('name', current.name);

       target.query();     // Issue the query to the database to get relevant records

       if (target.next()) {

               // add code here to process the incident record

               gs.addErrorMessage("Location Name already exists.");

               current.setAbortAction(true);

       }

Thank you Srnewbie for your response,   code is working fine

Hi Divya,

You can achieve this oob by updating the unique flag on the name field.

OR

Write an onbefore insert business rule on location table for validation.

var gr = new GlideRecord('cmn_location')

gr.addEncodedQuery('name='+current.name);

gr.query()

if(gr.next()){

gs.addInfoMessage('YOUR MESSAGE HERE');

current.setAbortAction(true);

}

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

Here is how you set the unique field for location name (The field need to be added in the form layout of dictionary)

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response