Skip to Content
This question has been flagged
constraintuniquestudiov15
2 Replies
6086 Views
Avatar
Caribbean Data Challengers

I need a new field in res.partner for account number. The number should only belong to one contact and must be created manually (no sequencing). How do we get a uniqueness check on that field to prevent duplicate entries and warn the user that the value already exists?

Avatar
Discard
Avatar
Melanie Turleque
Best Answer

Hello, would you by any chance know the python code to use ?

Thanks a lot.

Avatar
Discard
Vikas Jadav

Hi,

You can use sql constraints.
_sql_constraints = [('name_uniq', "unique(name, applicability, country_id)", "A tag with the same name and applicability already exists in this country.")]

Avatar
Niyas Walnut
Best Answer

Hi,

You can create an automated action in the database, that is getting triggered on writing or creating record in this model and you can raise warning if duplicates are found.


Check whether base_automation module is installed in the database, if not install it, then keeping the developer mode activated, navigate to Automated Actions menu under the settings and create a new record here, select triggered on Create & Update and execute a python code, that check and raises the warning.

Thanks

Avatar
Discard
Related Posts Replies Views Activity
unique constraint on 2 fields one of them is many2many Solved
constraint unique many2many v15
Avatar
1
Feb 22
4575
Restrict Studio ,to users Solved
studio v15
Avatar
Avatar
1
Dec 24
3708
Odoo Studio - V15 - Create new field in Contact Module.
studio v15
Avatar
0
Dec 21
3076
How can i add Unique constriant to field in openerp? Solved
constraint unique
Avatar
Avatar
Avatar
Avatar
Avatar
4
Mar 15
13131
Raise Warning
warning studio v15
Avatar
Avatar
Avatar
2
Aug 24
16695