Looking for some bright minds who maybe see a workaround for my problem:
We want to use the standard matching rules to identify potential duplicate contacts. An issue that keeps coming back is: we want to match records with filled in value vs empty value. Example:
- FirstName "Robin" and FirstName "Robin" should match
- FirstName "Robin" and FirstName "George" should not match
- FirstName "Robin" and FirstName empty should match
The last point does not seem possible using matching rules, since setting "Match Blank Fields" to true will only allow for:
- FirstName empty and FirstName empty should match
The only way to do this I see, is leave FirstName out of the matching criteria as a whole (thus the returned duplicate record set will contain too many items) and then later on fire some apex magic that deletes duplicate record items with filled in but different first names.
Is there any option I missed?