Print this page

Duplicate Rules aren't picking up duplicate City Names

Knowledge Article Number 000221248
Description When setting up Duplicate and Matching rules, using City as the criteria may not bring up a warning or blocker when creating new records - this can be expected.
Resolution The Duplicate and Matching rule setup currently looks for the first 100 records to match against.

So for example, if an Org has 500 records with a city of Houston - and a user tries to create a new record using Houston as the city, Salesforce will only look at the first 100 Houston records to try to find a match - if no match is found, there will be no duplicate warning.

Specifically - if there is an address of 111 Acme Blvd, Houston, TX - and the user has a matching rule on Street and City - Salesforce will look at the first 100 Houston records. If no 111 Acme Blvd in Houston is found in those first 100 records, there will be no match.

promote demote