Articles in this section
Authenticate Emails with SPF, DKIM, and SenderID Auto forward your emails to Vtiger Managing User Profiles Automate Outgoing Emails in Email Settings Automation - Approvals Automation - Assignment Rules Set up Multi-path Workflows Creating a Scheduled Workflow Automation - Scheduler Creating a Workflow Webforms in Vtiger CRM Set up a Workflow Action to Create Event Set up a Workflow Action to Create Records Set up a Workflow Action to Create Task Set up a Workflow Action to Invoke Custom Function Set up a Workflow Action to Create an SMS Task Set up a Workflow Action to Send Mails Set up a Workflow Action to Update Fields Automation - Workflow Action - Webhook Automation - Workflows - Vtiger Expressions Configuration - Business Hours Configuration - Company Details Configuration - Consents Configuration - Customer Portal Maps in Vtiger CRM Configuration - Usage Details Configuring 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 Dealing with Currencies and Taxes Enable Desktop Notifications on Chrome Web Browsers Vtiger CRM Add-ons IMAP Configuration - 2-way sync between Vtiger and IMAP providers Setting up Autopay & Payment Gateways Inventory - Tax Management Inventory - Terms and Conditions Login to Vtiger on SSO SAML using ADFS Mailroom Functionality for Different Scenarios Manage Multiple Currencies 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 Configure My Preferences Feature My Preferences - Calendar Settings Tags in Vtiger My Preferences - Notification Preferences SAML Support in Vtiger CRM Vtiger 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 Add-Edit Unsubscribe Links in your Email Template 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 Vtiger Language Support Configuring Websense Trackers Websense - Widgets Module Management - Module Layouts & Fields Generate and Manage Third-party App Passwords in Yahoo Configuring App Passwords for Gmail Outgoing Server and Yahoo Mail Configuration - Storage Guard Customizing your Self-Service Portal Theme Using CSS Styles Automation - SMS Reply Actions Adding Hidden Fields to a Webform Configuring Dependent Fields and Blocks for Modules Auto forward Emails from Microsoft Office 365 Adding Custom Module Login Page Customization Settings - Personalize Module Layouts Module Management - Modules Formula Fields Creating Custom Filters Adding a local DNS Entry

Duplicate Prevention in Modules

This article will help you prevent the creation of duplicate records.
R
Rashmi Kashyap
27 Nov, 2023 - Updated  1 year ago

Introduction

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.
 

Note:

  • 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.

Exceptions

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
Home Privacy Policy Terms of Service Security Center Policy & Legal Center Contact Us
© Copyright 2025 Vtiger. All rights reserved.
Powered by Vtiger
Facebook Twitter Linkedin Youtube