1

I have a group of contacts that are organizations. They are institutional members of the organization I'm working for. That part works fine. We are trying to send a renewal email and the normal way to do this seems to be using the "on behalf of" option on the contribution page. All that works as expected. It fails if I arrive with a CID and checksum that makes me the org, but succeeds if I arrive with a CID and checksum that makes me a related contact. All well and good.

I have created an "Primary contact for" relationship for each org so I don't email every single person related to an organization. It seemed a simple enough solution, but I can't find a way to make a smart group that captures the primary contacts of a group of organizations.

I started with Search Builder as it appeals to my brain. I failed as I can't find relationships exposed anywhere in this tool.

I can use Advanced Search to find individuals who are primary contacts, but not just the primary contacts whose organizations are in a particular group or have a particular membership status.

I have attempted to make use of Jon G's SearchKit suggestion, but am still getting stuck with variations of the relationship problem.

I have replicated what he suggested and do get results that seem initially promising, but there are too many to possibly be just the primary contacts for these orgs (there are only 75 primary contacts in total) and indeed the first entry in the list is not a primary contact for anyone.

enter image description here

I then tried to add a filter at right to limit the results to primary contacts only. The right options seemed to be available, but now the results set is empty.

enter image description here

I would appreciate any further thoughts to augment my admittedly poor grasp of SearchKit.

1 Answer 1

1

I had the exact same need last week! I'm attaching a screenshot from SearchKit, though you probably need something simpler. But crucially:

  • Contact Related Contacts is what you're looking for (see screenshot item 1). You can specify the relationship type.
  • You can create a smart group from the Add button (item 2).
  • You can see I also am filtering here on organizations whose membership end date is in the past.

What's odd is that I used the CID of the org, and it did work. We needed this so the payment was associated with the org, not the primary contact. I used SearchKit Tokens to create a "Organization's CID" and "Organization's Membership Type" token for individuals. We didn't use checksums because these users have to log in to renew. We send them to a FormBuilder page though - which in turn redirected to a contribution page, so maybe that's why it worked.

enter image description here

2
  • Thank you @jon-g-megaphone-tech That was very helpful, but I'm still not managing to limit it to primary contacts. I wonder if you might take a look at my updated question and offer additional thoughts.
    – kapn
    Jan 19 at 17:12
  • @kapn Your relationship join is set to "With (optional)". Set it to "With (required)"? Jan 21 at 22:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.