Hi Tameem,

I think you are trying to make the Unique field.

Usually, this is handled by SQL Constraints. In your case, you are using Odoo Online. So we must think differently to make it possible.

Anyway

Try this way. Maybe you will get the result you wish.

1. Create an Automated action with the following parameters.

• • Model: your custom model

  • Trigger Condition: On Update

  • Action To Do: Execute Python Code

  • In the python code, try this code

new_value = record.YourFieldName
existing_records = env['Your.Model'].search([('YourFieldName', '=', new_value)])
if len(existing_records) > 1:
      raise Warning('Field value must be unique')

Thanks