• Skip to main content
Client Portal
(888) 391-4493
  • Salesforce Services
    Salesforce Managed Services

    Maximize your ROI and say goodbye to costly in-house Salesforce staffing with StarrData Team as a Service.

    Salesforce Administration

    Stop worrying about the day to day details of Salesforce and outsource to a 5-star certified Salesforce team.

    Salesforce Implementation

    We'll help you get up and running quickly - from simple implementations to fully customized instances.

    Salesforce Optimization

    Get the most out of your Salesforce investment by fine tuning your instance specifically for your needs.

  • Salesforce Clouds
    Salesforce Revenue Cloud
    Salesforce CPQ

    Deliver fast & accurate proposals that empowers your sales team and maximizes company revenue.

    Salesforce Products
    Sales Cloud

    Empower your sales team by leveraging best practices throughout the company.

    Experience Cloud

    Connect your customers, employees & partners with the power of Salesforce.

  • Who We Serve
  • Success Stories
  • Blog
  • About
    Guaranteed Customer Satisfaction

    A commitment to customer satisfaction doesn’t go far without a process for ensuring it. Learn how the StarrData Action Loop works to guarantee customer satisfaction, eliminating misunderstandings and scope creep.

    5-Star Certified Salesforce Partner

    Since 2009, StarrData has helped hundreds of companies leverage the power of Salesforce. We are a 5-star certified partner with an experienced team of consultants, solution architects, engineers, and administrators.

    Success Stories & Testimonials

    Read first-hand accounts of how StarrData solutions, customizations and ongoing support helped clients in multiple industries get more out of their Salesforce investment, enhancing productivity and customer satisfaction.

    Commitment to Equality

    At StarrData we believe that all humans are equal, and diversity is a strength. We are committed to providing equal employment opportunities and world-class service to anyone, regardless of sex, color, gender, religion, or sexual orientation.

  • Talk to an Expert

Preventing Salesforce Duplicates

By Darren Starr
Linkedin
X (Twitter)
starrdata-logo

Preventing Salesforce duplicates will save you heaps of time in the future. Just like any other CRM database, no matter how hard you try to keep them out, Salesforce duplicates (salesforce duplicate records) are going to happen.

Download Our Free Guide With Salesforce Best Practices

A user may fail to search first before creating a new record in Salesforce.

A user may search Salesforce first but does not see the duplicate record due to Salesforce sharing settings.

Or a user (or admin) may upload files into Salesforce from a service with a tool that does not check for duplicate records. Either way, it is an ongoing process to keep the database clean.

Salesforce duplicates can cause all sorts of issues: from wasted effort to upset customers and user apathy.

  • Multiple reps could be working the same account without knowing it.
  • Reporting can be skewed from the extra records.
  • Customers could be contacted by different reps on the same subject, be it a sale or case.
  • All of this results in users eventually quitting using Salesforce since they have to wade through a bunch of records to find the proper one.

There are some steps you can take to keep Salesforce duplicates to a minimum including:

  • Instructing users on how to search before creating a record.
  • Limiting imports to only a few key people.
  • Using a third party app from the AppExchange like RingLead or Dupe Blocker.

Salesforce Enterprise users have an additional option using workflow and unique fields to create your own Salesforce duplicate record blocking tools.

What follows are the steps to stop Salesforce duplicate contacts from being created or uploaded regardless of your sharing settings. This does require a required field. For the contact records, I recommend making the standard “Email” field required on the page layout.

Create a new text field on the Contact object and call it something like “Duplicate Test”. Set the attributes so that it is unique and not case sensitive like the picture below. You do not need to add the field to any page layouts.

preventing Salesforce Duplicates, Salesforce Partner, StarrForce

Then create a workflow rule that fires “every time a record is created or edited” with the following formula criteria:

OR(

ISBLANK( Contact_Duplicate_Test__c ) ,

ISCHANGED( Email ) ,

ISCHANGED( LastName )

)

You can change the “Contact_Duplicate_Test__c” to the name of the text field you created. You want the rule to look like the picture below with your field name in the place of mine.

preventing Salesforce Duplicates, Salesforce Partner, StarrForce

After saving the workflow rule, add a field update to update your unique text field with the following formula that concatenates the Last Name, a dash, and the email address: (picture below)

LastName  & “-” &  Email

preventing Salesforce Duplicates, Salesforce Partner, StarrForce

Activate the workflow and give it a test. In the picture below, you can see my test field on the bottom left.

preventing Salesforce Duplicates, Salesforce Partner, StarrForce

When I try to create a new contact with the same last name and email address, I get the error in the picture below and I am unable to save the record:

preventing Salesforce Duplicates, Salesforce Partner, StarrForce

Since the “unique” attribute works at a system level, this will work even if the user does not have permission to view the existing record. They could click the name link in the error but they would only get an error page that they do not have permission to view the record.

It also works when uploading records with the Data Loader or another tool. The Data Loader will return the failed uploads in the error file, allowing you to cross reference them to see if they need updating or not.

You can create the same setup on the Lead object as well using the same fields. Or you can use any other fields that are unique when combined. For accounts, you may want to use the Account Name combined with the Billing or Shipping Address Street and State. For opportunities, the Opportunity Name combined with the Account Name and the Amount may work for you. The possibilities are endless. You just want to make sure you are combining fields that result in a unique test string that would only be duplicated if the record was duplicated.

 

Want to learn more about clean data in Salesforce?

Download our FREE list of Salesforce Best Practices!


Download Our Free Guide With Salesforce Best Practices

StarrData is a Salesforce Partner that helps companies deploy, optimize and support Salesforce.com. If you would like information on the services we offer call us at (888) 391-4493 x101.

Posted in Cloud Computing, Salesforce Best Practices, Salesforce Support, Salesforce.com
StarrData Logo

StarrData

3527 Mt. Diablo Blvd. #392
Lafayette, CA 94549

(888) 391-4493 x101

info@starrdata.com

Popular Links

  • Salesforce Implementation
  • Salesforce Managed Services
  • Salesforce Optimization
  • Salesforce Administration
  • Salesforce CPQ

Follow Us

Copyright© 2024 | Privacy Policy

Our Spring Sale Has Started

You can see how this popup was set up in our step-by-step guide: https://wppopupmaker.com/guides/auto-opening-announcement-popups/

Our Spring Sale Has Started

You can see how this popup was set up in our step-by-step guide: https://wppopupmaker.com/guides/auto-opening-announcement-popups/

Contact Us Today

To speak with someone right away, give us a call at (510) 984-3648.

  • This field is for validation purposes and should be left unchanged.