Skip to main content

#Duplicate Management1 discussing

The standard account matching rule is flagging suspected duplicate accounts in my system that are NOT duplicates. 

* If I delete the Duplicate Record Set that is auto created (i.e. image 1 below), then that at least removes the flagged duplicates from my reports/ list views..... HOWEVER, the individual account records still show a suspected duplicate in the potential duplicates component on our lightning pages. 

 

Is there any way to get that alert to go away too (see image 2 below)?

 

*Note - we are not blocking duplicate creation, just flagging and reporting on them.

 

Flagged Duplicates are NOT Dupes, how remove the

*Deleting the DRS record removes the flagged dupe from reports/ list views..

 

DupeAlert.JPG

*Yet this potential dupe alert persists after the DRS is removed. Is there a way to also remove the suspected dupe flag?

 

#Data Management

 

@* Sales Cloud - Getting Started * @* Sales Cloud - Best Practices * @* Service Cloud *

2 answers
0/9000

Concept is simple: Think of companies with multiple store locations (like Starbucks) – there are multiple locations in a single city, but these Accounts are not duplicates -- the account name is similar, but the store number is unique.

We want fuzzy match on account Name to assist with preventing duplicates on account creation.  However we want the  matching rule to not-make-a-match if the Store Number value is different.  (Store Number field on the account is unique)

 

We essentially want to be able to have the Matching rules IGNORE the fuzzy match on Account Name if the values in Store Number field are different, but not blank.  

 

Example:

Existing Account:  Name = "Freeman, Inc"  Number = "1234"

New Account 1:  Name = "Freeman, Inc"       Number = "5678" --> desired result: No Match

New Account 2:  Name = "Freeman"             Number = blank --> desired result:  Match

 

Is there a way to do this with the standard Matching/Duplicate rules in Salesforce that we are simply overlooking?

4 answers
0/9000

I'm not sure if there's a solution out there for this but it's worth a shot! I've got matching/duplicate rules set up for Accounts and Contacts. However, we have a duplicate problem largely because reps will sometimes abbreviate an account name to ABC instead of typing it all out. My matching rule isn't set to catch when that happens:

Account: PhoneEXACTMatchBlank = FALSE) OR (Account: NameFUZZY: COMPANY NAMEMatchBlank = FALSE) OR (Account: WebsiteEXACTMatchBlank = FALSE

Is there a way to help the rule catch these potential duplicates by their abbreviated account names? I ask because I noticed that Global Search will pull up accounts like this for me. If I type in the abbreviation it will also show me an account with the name spelled out.

I'm also struggling because if I'm creating a new account that only contains one word that matches a different account the rule won't catch it. Which is probably for the best - I don't want it to pull up a million possible duplicates because my new account has "the" in its name. But, if I have three duplicate accounts such as "Soup Cans," "Cans of Soup," and "Celery In Soup" I'd really like my alert to pop up if someone tries to create an account that is simply titled "Soup."

Sorry for the book! Any ideas?

15 comments
0/9000

Hi,

 

I am trying to create custom matching rules to identify duplicates . I want to include the record type field to restrict search accounts with same record type and unable to find an option. In my scenario there could be duplicate accounts in different teams with different record types and I want to throw duplicate error only if there exists an account with same name within the same record type.

 

I was unable to even add a matching criteria for a custom field. Please suggest how to resolve this.

 

Thank you,

Aruna

11 answers
  1. Sep 27, 2024, 2:00 AM

    @Jesús Romo here are some comments:

    1. Duplicate Rule checking is initiated in the background every time you create or update duplicate rules.  This covers the retrofit of existing records, but take heed: it runs in the background and with a large database can take quite some time to complete.
    2. Default field values are assigned before the field is displayed in the UI.  The documentation doesn't say at what point this value is saved when the record is created without UI, but I guess it would be after all automations are run (pre and post save), if no value is assigned to that field.
    3. What I understand from your comment is that you have two separate requirements: (a) to ensure a single account has no more that one of each address type, and (b) that the Address object has no duplicate records.  Is that correct?  For (a), you could create a record-triggered flow on Address object, which counts the different address records for an account and checks there for duplicates, displaying a custom error message if the user is trying to break the rule.  This would only work for new and changed address records, of course, so you'd need a way to review existing accounts. For (b) you can create a matching rule on Address, using the important (up to 5) fields such as Address Type, City (Fuzzy), ZIP (Fuzzy), State/Province, Country, then use this for a new Duplicate Rule.  Once you activate the rule, this will allow you to create a report type for Addresses with Duplicates.
0/9000

Hello - I installed the Duplicate Record Check Apex Action from Ryann Mercer, but it does not appear to be working.  I am creating a contact that I know is a dup, to test it out, but it's not finding it.  I am using it on the Contact Record with some custom dup rules that I have created.  I know there is a way to check for dups in the newer version of Flow, but it doesn't always work, if there is a misspelling in the name (no fuzzy matching), so I was hoping this would at least help.  But it doesn't appear to be working.  I "think"  I set it up correctly, using a Single record collection variable, etc.  Thoughts?

 

#Unofficial SF #Duplicate Management

 

Dup Record Check - Not Working?

 

dup check 2.png

 

dup check 1.png

1 answer
  1. Andrew Russo (BACA Systems) Forum Ambassador
    Sep 23, 2024, 9:54 AM

    i have used this one and it works great

    https://unofficialsf.com/validation-checker-flow-action/

0/9000

Hi Experts,

 

I am experimenting with the Web to Lead feature, see article:

https://help.salesforce.com/articleView?id=sf.setting_up_web-to-lead.htm&type=5

 

Thsi feature seems to automatically block duplicates.

If I try to add a duplicate, it will simply not create the lead an send me an error via mail.

 

I want to allow duplicates, and manage them by myself in the system, since many duplicates are expected for my case. 

 Can anyone share their experience with this?

 

Thank you in advance.

#Web-to-lead #Duplicate Management

4 answers
  1. Jul 26, 2021, 12:43 PM

     Hey Niklas,

     

    To allow a duplicate Lead to be created through Web-to-Lead, consider 

     

    1. Add a Condition on the existing Duplicate Rule such that it does not run when the current user is the default Web-to-Lead creator. 

    2. Create another Duplicate Rule that runs only when the current user is the default web to lead creator, and set that rule to allow and report (without alert).  

     

    For more reference: https://help.salesforce.com/articleView?id=000336839&mode=1&type=1

     

    Let me know if this helps, also if there is anything else.

     

    Thanks,

    Tanaya 

0/9000

Hi,

 

I need to create a Matching and Duplicate rule for the standard object " Location" but unfortunately this object is not listed.

Any ideas why or how can I accomplish this?

 

Thanks in advance

2 answers
  1. Aug 2, 2024, 11:15 AM

    Hello @Nadia Bica,

    You can create duplicate rules or matching rules for the following standard objects:

    1. Leads

    2. Contacts

    3. Accounts

    4. Person Accounts

    5. Individual

    6. Address

    Hello ,You can create duplicate rules or matching rules for the following standard objects:1. Leads2. Contacts3. Accounts4. Person Accounts5. Individual6.

0/9000

In NPSP I created matching rules for Classy based on contact emails. If the donor’s email  in Classy = HomeEamil or WorkEmail or AlternateEmail it would be considered a match.

This was easy since these fields resided on the Contact record. However, In EdCloud there is the Contact Point Email object. I am very curious to see how people are addressing matching rules that could accomplish the same type of matching rule given the fields are on a different object?

 

Any help would be appreciate!

 

#Duplicate Management #Education Cloud

1 answer
  1. Jun 20, 2024, 11:17 PM

    We are recreating similar fields on the contact and using flow rules to update them from contact point records. So for example. We add mobile phone to contact. We update it with the primary active mobile contact point phone. 

0/9000

Hello I'm hoping someone else has encountered this problem before. I am seeking input on our current approach to managing duplicate leads. Currently, when a lead returns, even after several years since their initial interaction, they are merged with their original lead entry. However, this method is posing challenges as our reporting and operations rely heavily on the Lead 'Create Date'. How are other customers handling leads that revisit?

3 answers
  1. May 10, 2024, 4:07 PM

    Devil's advocate but wouldn't you want duplicate Leads to merge because ultimately unless you're not using Opportunities, that is where metrics should exist for whether sales actually happened. Ten separate Jim's who come in as Leads don't tell you as much as one Jim and ten Opportunities where that information should be captured. 

0/9000

Hello,

 

we have fuzzy duplicate rules which are fine, but in some cases they detect "false positives". With the component "potential duplicates" on the account record page the message is prompted, that there may be duplicates of this record.

 

So far, so good. But in case of a false positive duplicate detection we'd like to allow the user to turn off the duplicate warning for the affected accounts. We tried to delete the corresponding DuplicateRecordSet and DuplicateRecordItems. But this has no effect, so the LWC for potential duplicates seems to do an instant check of the hash values.

 

What would be a good practice to "switch off" dedicated duplicate warnings? And who is the consument of the DuplicateRecordSet and DuplicateRecordItems? Is there another duplicate warning which depends on these entries we could use instead?

 

Regards,

Stefan

 

#Duplicate Management

2 answers
  1. May 3, 2024, 6:16 AM

    Hello @Roberto Ortega! Thank you for your reply.

     

    No, unfortunately that would not do the trick. I want to remove a specific duplicate set as a false positive. I don't want to exclude a specific account from all further duplicate checkings against new accounts in future. If a similar account is created again in the future, a duplicate check should of course be carried out again.

     

    I hope I was able to describe the requirement well enough?

0/9000