Advanced Custom Deduplication Using Salesforce Formula Fields
Need sophisticated duplicate detection? This tutorial shows how to create custom dedupe jobs using formula fields for multi-field matching, data manipulation, stop-word removal, and fuzzy matching.
What You’ll Learn
Formula as Dedupe Criteria: Set custom formulas as your main matching key
Multi-Field Matching: Combine multiple fields into a single match key
Data Manipulation: Remove portions of data or stop-words before matching
Spelling Tolerance: Configure fuzzy matching to ignore minor variations
Merge Strategy Selection: Choose field-level and related-list merge strategies
Example Formula Use Cases
Combine First Name + Last Name + Company for contact matching
Remove “Inc.”, “LLC”, “Corp” from company names before matching
Standardize phone formats for phone-based deduplication
Create composite keys from multiple address fields