Find and merge duplicate records
Duplicate records pose a significant problem when you work with large volumes of data. It is important to keep your database free from duplicates to ensure your business runs efficiently. A database containing duplicate records doesn't offer easy access to the complete communication log with a customer, wastes sales reps' time, and generates inaccurate reports which will affect business decisions. Bigin provides you with a proactive solution by preventing duplicates from entering your database and a reactive solution by merging existing duplicate records.
Avoid duplicate records
The
Do not allow duplicate values checkbox in the field's settings prevents duplicate records from being created. Once a field has this option enabled, the system will not allow another record to be created with the same field value. For example, you have enabled this option for the
Email field in the Contacts module. Now, you cannot create a record in the Contacts module with an email address that is already associated with another contact.
There cannot be two records with the same email address.
To avoid duplicate records
- Log in to Bigin with admin privileges.
- Go to Settings and then Fields and select the desired module.
- Go to the desired field and click the edit icon.
- Select Do not allow duplicate values.
- Click Save.
Note: The
Do not allow duplicate values option is not available for the Activities module.
Find duplicate records
If you have not enabled the
Do not allow duplicate values checkbox for the Contacts or Companies module there is a risk that your database might contain duplicates. Bigin lets you find duplicates of a record and merge them into one record. This is a two-step process. First, you find the duplicates based on one or more field values and second, you select one of the duplicate records to be the master record and merge the details from other records into it. The master record is the record that will be retained and other records will be permanently deleted after merging. A maximum of three records can be merged at a time.
To find duplicate records
- Go to the Contacts or Companies module.
- Click the desired record.
- In the Details page, click the more icon and then click Find & Merge Duplicates.
- Specify the criteria for finding duplicate records in the Search Criteria section.
- Click Search.
The matching records will be listed so you can identify duplicate records. - In the Merge section, select the records you want to merge.
- Click Next.
- Select the record that you want to set as the Master Record.
- Click Select All if you want to take all the master record's values as the final values and merge the duplicates. Or click the radio buttons next to the fields for other records to take those values as final values and merge the duplicates.
- Click Merge.
All selected values from the duplicate records will be merged with the master record. All the related records of the duplicates (Attachments, Notes, and Activities) will be merged with the master record.
Note:
Find and merge lets you merge duplicate records into a single master record and delete the duplicate records. The record which is retained is considered the master record and the deleted records as duplicate records. Automation actions that are triggered on Edit will be executed when the master record is updated and automation actions that are triggered on Delete will be executed when the duplicate record is deleted. For instance, if you have a workflow rule that sends an email alert when a record is deleted then this workflow rule will be triggered when a duplicate record is deleted.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
iPhone - Delete a record
The deleted records will be moved to the recycle bin. To permanently delete a record from the recycle the user must be an Administrator in Bigin. To delete a record Go to the desired module. Tap the record that you want to delete. Tap the More icon. ...Android - Delete a record
The deleted records will be moved to the recycle bin. To permanently delete a record from the recycle bin, the user must be an Administrator in Bigin. Go to the desired module. Tap the record that you want to delete. Tap the Delete icon. ...How is the record limit calculated?
The record limit of 50,000 records (Express), 100,000 records (Premier) and 1 Millions records (Bigin 360) includes the records in the Pipelines, Companies, Contacts, Products, Notes, Tasks, Events, and Calls modules. There is no limit on the number ...Search and sort records
Search records A typical day in the life of a sales rep involves checking and replying to emails, making calls, following up with leads, and helping customers find what they want. They must also keep a record of all relevant information about each ...Android - Sort your records
You can sort your records based on how you want to see your data. For example, if you’re working in Contacts, you can find sorting criteria relating to that module like First Name, Contact Owner, or Last Name. Similarly, you can sort the records in ...
New to Zoho LandingPage?
Zoho LandingPage Resources