How to check duplicate email when create new customer?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

All apps

2 ตอบกลับ

4998 มุมมอง

how can I check duplicate email when create new customers? Can anybody help me ? Thanks!

ผู้เขียน

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

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

Related Posts	ตอบกลับ	มุมมอง
Where can I check the emails I have sent from my database in Odoo? email emails	1 ก.พ. 25	1255
How to add outgoing mail into the customer(receiver) page not the partner(sender) page. email emails customers odoo odooV12	0 เม.ย. 21	2221
Connection test failed! Error while configuring outgoing mail server. แก้ไขแล้ว configuration email emails	4 พ.ค. 24	38489
How to identify bounced email? email emails emailing	1 มี.ค. 24	2651
Difference between Messages and Emails แก้ไขแล้ว email emails messages	2 ธ.ค. 20	6184