Identify and Eliminate Duplicate Records


Free Salesforce business guides to help admins/developers, project managers, sales managers, and decision makers. Download the free PDF series now: Reinventing Your Business, Reimagining Your Salesforce®.

Problem: When a user manually enters the information for a contact and searches Salesforce for the appropriate account, it adds extra steps and increases the chance that duplicate records will be created.

For example, if the user doesn’t find the account, then they will need to create one. Next, they would need to fill in the required fields on the account (many of which might already be on the account), and associate this newly created account to the contact. The manual search process is unreliable, increases the possibility of account duplicates, and wastes valuable selling time.

Solution: Lookup Helper will automatically relate records based on the criteria the Admin has set.

Since new users don’t need to manually fill in those lookup fields, it reduces the number of steps that are needed. Lookup Helper automatically looks for any already existing match to the criteria, reducing situations of users not finding the record and eliminating the creation of duplicate records.

Example: You can create a Lookup Helper Setting that relates a Contact to an Account automatically by comparing a text field "Company" on the Contact to the Account Name.

You simply need to enter the contact information and fill out the "Company" field with the name of the contact's company. Lookup Helper will then search for an existing account with that name. This allows Lookup Helper’s powerful search to find the best matching account to link to the contact. 

image (7)

How it works inside of Lookup Helper:

  • With "Create New Category Records" enabled, Lookup Helper automatically creates an Account with the appropriate name (and other fields if so defined in the "Fields to Populate" section of the Lookup Helper Setting) when it doesn’t find a matching account.
  • Lookup Helper associates the Account with the Contact.
  • The possibility for user error when creating the Account is removed since Lookup Helper automatically finds the best matching account.

  1. Select a child object you would like to create or maintain a relationship on. Contact has been selected in the image below.

Select a child object

  1. Select or create a lookup field.

create a lookup field

  1. Select fields on the contact and account to match. In the image below, "Company" and "Account Name" have been selected. 

Select fields on the contact and account

  1. Check the “enable the creation of category records” box.

enable the creation of category records


Multiple Matching Parent Record Alerts 

If Lookup Helper runs and finds more than one potential matching parent record, it will send an email alert to the Admin, letting them know multiple matching parent records exist, along with the ID’s of the records. For instance, in the above example that uses “Contact and Account,” a "multiple matching records" alert indicates two accounts with the same name exist in the org and might be duplicates.

Salesforce Reports for Time Entry Logs from Milestones PM+ Lookup Helper Use Case Library Number of Tasks From Lead Owner