Using Search Builder to find all contacts who might be linked to the same membership record

Using Search Builder to find all contacts who might be linked to the same membership record

When trying to find contacts who have memberships matching assorted criteria, you can use Search Builder to find contacts who are listed in the Member field, or the Member 2, 3, 4, 5, 6 or Billing Contact fields of their corresponding membership record. See screenshot below:



When you are setting the search criteria in Search Builder, there is a drop-down menu that allows you to tell Sumac which Member Contact field you want the criterion to consider. By default, it is set to "Member," but if you open that drop-down menu, you can set it to look at Member 2, 3, 4, etc., or the Billing Contact instead. For example, when trying to narrow in on any contacts who have Family Memberships, set a criterion that looks at the Member Contact, and create a duplicate criterion that looks at Member 2, another for Member 3, etc., then combine them with an OR connector.

This approach allows you to find all contacts who may be linked to a membership for a more complete final list.
    Societ Academy

    Learn what you need to know, any time. Free!



    • High quality training on demand - sessions are available every day, so you can access training that fits into your schedule.
    • Training sessions that are easy to follow - helpful tips throughout each session, and access to training moderators ensure your questions get answered.
    • A certificate of completion - you can request a certificate of completion for every session you attend.