how can I check duplicate email when create new customers? Can anybody help me ? Thanks!
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Účetnictví
- Sklad
- PoS
- Projekty
- MRP
This question has been flagged
2
Odpovědi
5950
Zobrazení
Can I use sqlconstraints to check duplicate email like this?
_sql_constraints = [ ('email_unique', 'UNIQUE(email)', "The Email must be unique"), ]
Are you Vietnamese, Can you contact with me?
My email address: volamtruong01999@gmail.com
Yes, why don't you try it now XD
I was tried but it doesn't working for me
Try this
@api.constrains('email')
def _check_duplicate_email(self):
for rec in self:
emails = self.env['res.partner'].search([('email', '=', rec.email)])
for obj in emails:
if obj.email:
raise ValidationError("Duplicate Email")
Hi, there are many ways
- Use Data Cleaning Apps (Odoo14 EE): It will find all duplicate records for you
- Use search bar (if you know which email is duplicated)
- Create a custom groupby for email field and find all the emails which have more than 1 record
- Create automated action (Odoo EE): and write python code to check the email field
- overwrite the create function of model res.partner
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Přihlásit se| Related Posts | Odpovědi | Zobrazení | Aktivita | |
|---|---|---|---|---|
|
1
úno 25
|
2724 | ||
|
0
dub 21
|
2941 | ||
|
1
pro 25
|
257 | ||
|
4
kvě 24
|
39980 | ||
|
1
bře 24
|
3710 |
