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
- 会計
- 在庫
- PoS
- プロジェクト
- MRP
この質問にフラグが付けられました
2
返信
5869
ビュー
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
| 関連投稿 | 返信 | ビュー | 活動 | |
|---|---|---|---|---|
|
1
2月 25
|
2534 | ||
|
0
4月 21
|
2896 | ||
|
4
5月 24
|
39794 | ||
|
1
3月 24
|
3639 | ||
|
2
12月 20
|
7212 |
