Full Access Salesforce Nonprofit-Cloud-Consultant Tutorials

In NPSP, there is a clear distinction between how we track "people to people" and "people to organizations."

People to Organizations (Affiliations): When a Contact (the volunteer) has a professional or community connection to an organization (Universal Containers), the Affiliation object is used. An Affiliation is a junction record that links a Contact record to an Account record with an 'Organization' record type.

People to People (Relationships): The Relationship object is used exclusively for person-to-person ties (e.g., "Spouse," "Coworker," or "Father"). You do not use the Relationship object to link a person to a business.

The Solution:

To track this volunteer's employment or connection to Universal Containers:

Step 1: Create an Account record for "Universal Containers" and ensure its record type is "Organization."

Step 2: Create an Affiliation record.

Step 3: On the Affiliation record, link the volunteer's Contact record to the Universal Containers Account record.

Step 4: Specify the Role (e.g., Employee) and mark it as the Primary Affiliation if this is their main employer.

Using Leads (Options A & B) is incorrect because the volunteer is already an established "Contact" in the system; creating a Lead would create a duplicate record and fragment the data history.

While Duplicate Rules and Matching Rules are essential for preventing new duplicates from being created, they do not help with a database that already contains existing duplicates (which is common after large direct mail imports).12

The Solution for "Auto13mating the Search":

On Unlimited Edition, Salesforce provides a feature called Duplicate Jobs.

Scanning the Database: Unlike rules that fire during a save, a Duplicate Job runs a scan across the entire existing database (or a specific segment) to find existing duplicate records based on your Matching Rules.

Reporting: Once the job completes, it generates a list of "Duplicate Record Sets." This allows the nonprofit's data integrity team to review and merge records in bulk.

Use Case: For a direct mail organization, running a Duplicate Job before a large mailing ensures they aren't wasting money by sending two identical letters to the same household.

Why other options are incorrect:

Duplicate/Matching Rules (Options A & C): These act as "gatekeepers" during data entry. They find duplicates only when a record is created or edited; they do not proactively "search" the existing database.

Scheduled Apex (Option D): This is a custom coding solution. A consultant should always recommend native, declarative features like Duplicate Jobs before suggesting custom code.