Learn to exclude Salesforce records from Delpha's duplicate detection using custom formula fields. Automate deduplication filters and improve accuracy.
In the article , we explained how to statically ignore records from Delpha’s duplicate detection using the D Do Not Compare checkbox.
This article shows how to take that a step further by creating a dynamic exclusion rule using a custom formula field. This lets you automatically exclude records based on business logic.
Go to Salesforce Setup → Object Manager.
Select the object (e.g., Account, Contact, Lead).
Click on Fields & Relationships → New → choose Formula as the data type.
Select Checkbox as the return type.
Example: To exclude Accounts with Record Type “Partner” or “Partner - Prospect”:
Open the Delpha Setup app.
Navigate to the Duplicate Configuration tab.
In the Duplicate Criteria Settings section, locate the field picker for D Do Not Compare.
Replace it with your
Once done, records where the formula evaluates to TRUE will be automatically excluded from the duplicate analysis.
Allows smart, dynamic filtering of records.
Saves duplicate credits by skipping records that don’t need to be compared.
Fits evolving business logic without manual updates.
Define your formula logic.
OR(ISPICKVAL(Type, "Partner"), ISPICKVAL(Type, "Partner - Prospect"))