Articles in this section
Authenticate Emails with SPF and DKIM Auto-forwarding your emails to Vtiger Automate Outgoing Emails in Email Settings Automation - Approvals Automation - Assignment Rules Automation - Multi-path Workflows Automation - Scheduled Workflows Automation - Scheduler Automation - Standard Workflows Automation - Webforms Automation - Workflow Action - Create Event Automation - Workflow Action - Create Records Automation - Workflow Action - Create Task Automation - Workflow Action - Invoke Custom Function Automation - Workflow Action - SMS Task Automation - Workflow Action - Send Mail Automation - Workflow Action - Update Fields Automation - Workflow Action - Webhook Automation - Workflows - Vtiger Expressions Configuration - Business Hours Configuration - Company Details Configuration - Consents Configuration - Customer Portal Configuration - Maps Configuration - Usage Details Configure Encrypted data fields in Vtiger CRM Configure Picklist Dependencies Considerations for Deactivating Vtiger Users Control Fields and Record Displays using Configuration Editor Create Reminders for Records and Inbox Create a field of a Grid type Customize your self-service portal theme using CSS styles Dealing with Currencies and Taxes Enable Desktop Notifications on Chrome Web Browsers Extensions - Extension Store IMAP Configuration - 2-way sync between Vtiger and IMAP providers Inventory - Payments and Subscriptions Inventory - Tax Management Inventory - Terms and Conditions Login to Vtiger on SSO SAML using ADFS Mailroom Functionality in Different Scenarios Manage Global Picklists Manage Multiple Currencies Marketing & Sales - Forecast and Quota Settings Marketing & Sales - Pipelines and Stages Marketing and Sales - Deal to Project Mapping Marketing and Sales - Lead Conversion Data Mapping Marketing and Sales - Profile Scoring Module Management - Labels Editor Module Management - Module Numbering My Preferences My Preferences - Calendar Settings My Preferences - My Tags My Preferences - Notification Preferences SAML Support in Vtiger CRM Set up Mailroom Settings - Configure Module Settings Settings - Create Dynamic Fields and Layouts Module Management - Creating a Relationship Between Modules Settings - Customize Records and Fields for your Business Settings - How to set email autoresponder to Webform submission? Settings - Left Menu Settings - Manage Global Picklists in Vtiger Settings - Set up your Support Team Settings - Start Up Page Settings - Working with Picklist Values Module Management - Module Builder Support - SLA Policies Troubleshooting Login Issues Unsubscribe your Email User Management - Authentication User Management - Encrypted Field Access Logs User Management - Groups User Management - Login History User Management - Profiles User Management - Roles User Management - Settings Log User Management - Sharing Rules User Management - Users User Management - Vtiger Support Access Vtiger Buzz - Chrome Extension for Notifications Vtiger Implementation wizard Websense - Trackers Websense - Widgets Working with Picklist field values Configuring Dependent Fields and Blocks for Modules Module Management - Modules Module Management - Module Layouts & Fields Configuration - Storage Guard

Duplicate Prevention in Modules

This article will help you prevent the creation of duplicate records.
Rashmi Kashyap
16 Mar, 2021 - Updated 29 days ago


Duplicate records in a module have the same name and information as one or more records in the same module. To maintain your data integrity, Vtiger helps you prevent the creation of duplicate records in the CRM from any source.

By removing duplicate records, you can eliminate identical information as well as save storage space in the CRM.

Watch this video for more information.


Note: If you already have duplicate records in the CRM, there is a way you can find them and eliminate them. To know more about finding duplicates, click here.


Sources of Duplicate Records

There are plenty of ways through which duplicate records can accumulate in the CRM. Duplicate records are created:

  • When you create, import, or perform a mass edit on records 
  • When you create records using  Quick Create
  • From Mailroom, Workflows, Webforms, and Chrome Plugin features

If you set up duplicate prevention, then duplicate records are not created from the above processes.

Setting up Duplicate Prevention

By setting up a ‘duplicate prevention check’, you can prevent users and external applications from creating duplicate records in a module. 

Follow these steps to set up duplicate prevention for a module:

  1. Log in to your CRM account.
  2. Click the User Menu on the top-right corner of the screen.
  3. Click Settings.
  4. Go to Module Management.
  5. Select Module Layouts & Fields.
  6. Select the module for which you want to set up duplicate prevention from the Select Module drop-down.
  7. Click the Duplicate Prevention tab.
  8. Turn on the Enable duplicate check toggle button.
  9. Select the fields (maximum three) based on which you want to run the duplicate check. For example, in the Deals module, if you select Deal Name, users will not be able to create a new deal with the same name as an existing deal.
  10. Enable either of the following settings:
    • Consider as duplicate only if all of the unique fields match - A record is considered duplicate if all the fields defined in the previous step matches
    • Consider as duplicate if at least one of the unique fields match - A record is considered duplicate if at least one field defined in the previous step matches
  11. Enable Check closed records also for duplicates to run the duplicate check on closed records. Disable it to ignore closed records while checking for duplicates.
  12. Enable Ignore blank values to avoid searching for duplicates on empty field names. Disable it otherwise. 
  13. Choose an action to take if a duplicate record is found while syncing with an external application.
    • Prefer latest record - The most recently modified record (CRM or external) will be retained.
    • Prefer internal record - The record existing in the CRM will be retained.
    • Prefer external record - The record in the external application will be copied and retained.
  14. Click Save.


  • You can set up duplicate prevention only if you are an Admin user.
  • Step 11 does not apply to the following modules: Deals, Tasks, FAQs, Price Books, Internal Tickets, Quotes, Purchase Orders, Campaigns, Service Contracts, Assets, Project Milestones, Projects, Cases, Work Orders, Credit Notes, and Documents.


Listed below are some features that don’t handle duplicate records:

  • Import Data
    • The unique field selected in Module Layouts & Fields > Duplicate Prevention does not affect the import process. 
    • A user must choose the fields manually in the Import Duplicate Handling step while importing data to the CRM.
  • Workflows
    • Update Field actions in Workflows do not check for fields enabled in Module Layouts & Fields > Duplicate Prevention.
  • Schedulers
    • The working of Schedulers does not check for duplicate records.

Other features like Recurring Invoices, Subscriptions - Invoice Generator, MailScanner, etc. that update or create records will prevent the creation of duplicate records but do not notify the user.

Related articles
Module Management - Labels Editor Module Management - Module Numbering Configuring Dependent Fields and Blocks for Modules
Home Privacy Policy Terms of Service Security Center Policy & Legal Center
© Copyright 2021 Vtiger. All rights reserved.
Powered by Vtiger
Facebook Twitter Linkedin Youtube