Big Little Things 91

Big Little Things – Find Duplicates

Welcome back to Big Little Things, where we highlight some of the lesser-known and sometimes overlooked features and enhancements in Vtiger CRM that pack a big punch. By taking a deeper look at and exposing some of these features, our goal is to help ensure our users are deriving the most benefits possible while using our CRM.

This blog highlights the Find Duplicates module. Let’s dive in and discover what the Find Duplicates feature is all about and how it can be used to clean up your database while ensuring that users have the most relevant up-to-date data in their CRM. We will also discuss a few other ways to find duplicates in the CRM using List View searches, One View, and Global Search.

What Is The Find Duplicates Module?


The Find Duplicates module is available in all editions of Vtiger and can be found in the Tools App under the Data Management category. It allows users to easily search for and identify duplicate records based on field values in specific modules. After identifying the duplicate records users can then decide how to best manage them.

Using Find Duplicates

Once the Find Duplicates module is opened, users will be prompted to select a module, list, and field(s) values that they would like to search for to identify duplicate records. Users also have the option to ignore empty field values and check closed records for duplicates.


After entering in all the criteria and hitting search, the system will quickly identify and present all duplicate records found, in a list view. From there, users can select the relevant records and decide how they would like to manage them, by using either the Delete or Merge options.


Merging Duplicate Records


When using the merge option, users can select up to three records at once to then merge into one. Selected records are displayed in a grid format allowing the user to select individual fields they would like to retain in the final merged record. It’s incredibly helpful to be able to get a clear visual of all the duplicate records with their fields laid out side-by-side. This ensures that users retain the most accurate and up-to-date information from all the duplicate records while also decluttering and cleaning up their database.

Deleting Duplicate Records


Deleting duplicate records is made easy using the Find Duplicates module. Users can simply select the duplicate records they want to delete and with a few clicks delete multiple records at once. Records that are deleted will also be stored in the recycle bin for 30 days before being fully deleted, allowing users to recover any records and their data deleted by mistake.

Other Ways to Find Duplicate Records

There are three other ways to find duplicates in the CRM. I have summarized them further, below:

One View

Duplicate9 One View Deal

After installing Vtiger’s Calculus AI Extension, users will be able to see and quickly access duplicate Deal records displayed while viewing a Deal record in One View. By default, Calculus AI checks the “Deal Name” field for duplicate text, but will also display duplicate records based on any fields you have set up using Duplicate Prevention on the Deals module.

List View Search

Duplicate7 List View

Users can use List View search to find duplicate records by entering unique values into the search boxes. Once duplicate records have been located, users can select multiple records and use List View Actions to merge or delete the records.

Global Search

Duplicate 8 Global Search

Similar to List View Search, users can enter unique values such as email addresses, phone numbers, etc… into the Global Search search box to find duplicate records. There are limitations on how to handle duplicate records after locating them using Global Search. For example, you cannot merge or delete records using the Global Search feature. You can only access the records individually to delete the records or revert to using the List View Actions or Find Duplicates features to merge or delete multiple records at once.

Take Vtiger for a Test Drive Today

Click here to sign up for a 15-day free trial or try our forever free Pilot edition.

Tags: , , , , , , ,

Blog Banner (1)

Implement organizational training in a cost-effective way with LMS

In the pre covid times, e-learning software was only seen as a technology that is used to enhance the learning experience. However, after the pandemic ...
Fun blog 4

All work and no play makes…why fun at work is important

If at all you see employees arguing at Vtiger, it will be because they think the Table Tennis table is being unfairly occupied by some ...
Importance of E learning

Six Benefits of e-Learning for Organizations

E-learning is gaining popularity in organizations for training and onboarding activities. Although the concept of e-learning was in place during the pre-pandemic period its demand ...
Meditation In Everyday Life Banner

Meditation in Everyday Life

In today's hi-tech, fast-paced lifestyle, life has gotten mechanical. It is about instant gratification with all sorts of luxuries and sophistication. On the other hand, ...
Big Little Things-Timelogs

Big Little Things: Timelogs

Welcome back to the blog series Big Little Things, where we highlight some of the lesser-known and sometimes overlooked features and enhancements in Vtiger CRM ...
Process designer manual trigger

Big Little Things – Process Designer’s Manual Trigger

Welcome back to another chapter in the blog series Big Little Things, where we highlight some of the lesser-known and sometimes overlooked features and enhancements ...
Productivity for Small Businesses Banner

Tools to Increase Productivity in Small Businesses

What is productivity? Productivity determines the standard of results. Productivity generally refers to the ability of an individual, team, or organization to work efficiently within ...
LMS for marketing training 2

Leverage LMS to Upgrade Marketing Skills

Marketing in today’s time requires a whole range of skills which include copywriting, analytics, content creation, etc., but not all employees in your organization will ...
blog Image 7

Vtiger LMS – Create custom courses that match your L&D needs

In our previous blogs, you have learned why a Learning Management System (LMS) is important for a business and how an LMS can help with ...
Upskilling Blog Banner

Upskill and Reskill: Be a better you

Times are changing quickly, and there is no denying that the pace of technological change continues to increase and in today's globalized world, demands on ...
Copyright 2022 Vtiger | Privacy | Policy & Legal Center