Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

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

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Prevent Leads Duplicate

Subscribe

Get notified when there's activity on this post

This question has been flagged
crmleadsOdoo13
4 Replies
12090 Views
Avatar
Yasser Hamed

Hello,
I want to make some fields on leads form unique for be sure not duplicate, is there an easy way to make it without add modules?
Best regards

0
Avatar
Discard
faOtools

have a look at this app - https://apps.odoo.com/apps/modules/13.0/crm_duplicates/ - possible to define any stored fields as soft duplicates (just to warn) or rigid duplicate (to restrict creation)

Avatar
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi,

As you are looking to do it from the user interface activate the debug mode and make sure that the module named(technical name) base_automation is installed in database.

Navigate to Settings -> Technical -> Automation -> Automated Action, here you can create a new record for this purpose, in the below example it is shown for preventing the duplicates in the field Email in crm.lead Model,


Give a name for the record let it be Prevent Duplicates in Lead, select the model as Lead/Opportunity, set trigger condition and in the action to do choose execute python code.

Python Code to add:

leads = model.search([('email_from', '=', record.email_from)])
if leads:
  raise Warning("Email Already Exists")


Click and save record, now when you create lead with duplicated email, it will raise warning like this,




Thanks

2
Avatar
Discard
Shanan

Is there any way, that I need to allow duplicates to prevent typing Extra Info every time and but I have to block the entering same name twice.

Eric Matthew Kerker

I tried this but now any lead or opportunity gets that message even when there isn't a duplicate. using v14.

Niyas Raphy (Walnut Software Solutions)

Try as follows,
leads = model.search([('email_from', '=', record.email_from)m ('id', '!=', record.id])
if leads:
raise Warning("Email Already Exists")

Avatar
Terje Tõnutare
Best Answer

Hey guys!

I tried to follow these instructions here. 

I have a custom filed done with studio for product shortname. Name of the field is x_studio_category_shortname_3

I tried to create an automated action.

Match records with the following rule:
Category shortname
is set

Wathed field is - x_studio_category_shortname_3

Python code is:

category = model.search([('x_studio_category_shortname_3', '=', record.x_studio_category_shortname_3)])
if category:
    raise Warning("Category Already Exists")


The warning appears only when I try to delete the category shortname. 
My expectation is to raise a warning when the name is duplicated. What am I doing wrong?

I hope my explanation is not too confusing. 

0
Avatar
Discard
Avatar
Yasser Hamed
Author Best Answer

can make it for many field or must creat new recoerd for every field ?

0
Avatar
Discard
Jacqueline Gleason

How would someone edit this code to work with Odoo 16?

leads = model.search([('email_from', '=', record.email_from)])
if leads:
raise Warning("Email Already Exists")

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Chande odoo default page to "Leads"
crm leads
Avatar
Avatar
Avatar
2
Aug 23
4062
How to generate leads from email
crm leads
Avatar
Avatar
Avatar
2
Apr 25
18031
Assign a Sales Team on a Lead Form in Website
crm leads
Avatar
0
May 20
3539
CRM leads upload via csv not creating new customers Solved
crm leads
Avatar
Avatar
3
May 19
4990
How do I show Leads in the portal "My Account" section of that user?
crm leads
Avatar
0
Oct 16
4562
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now