Skip to main content

Search and Filter Constituent Records

Find the constituent profile through various search and filtering options.

Cristina Gruita avatar
Written by Cristina Gruita
Updated over a week ago

There are a number of ways that you can locate the constituent profile that you are looking for:

If you know the constituent number

  • Type #12345 into the quick search box at the top-right of the screen (replacing 12345 with the constituent number you're looking for).

  • This will take you to that constituent.

Searching

You can search for constituents using a search term.

Quick Search

The quick search is always visible in Donorfy at the top-right.

When you enter a search term and click Enter (or click the magnifying glass), Donorfy will search across:

  • Constituents.

  • Opportunities

  • Campaigns.

    The search results are displayed in a grid, from which you can download a CSV file, add tags or produce a PDF list. The maximum number of results returned in quick search is 75.


Constituents | All Search

There is a constituent search within Constituents, All:

mceclip1.png

The search results are displayed in a grid, from which you can download to CSV, add tags or produce a PDF list. The total number of rows returned is shown at the bottom on the screen. When viewing in Grid mode (see buttons top-right) you can select the columns to be displayed. Column selection is limited - if you need to view or download all the available constituent columns you should use a List instead.

How to search

Type in the words you want to search for, if you enter 2 or more words constituents matching all the words will be returned - sorting by closest match can help you find what you want if your search returns lots of matches.

πŸ€“Tip:

  • Donorfy searches across the whole constituent profile, not just names.

  • A search for Paul West will show constituents with both Paul and West anywhere in their profile, including names and addresses.

  • Searches are not case-sensitive.

πŸ“ŒNote:

  • The searches will only return results for searches starting with three or more characters where there's a match.

  • You can search based on two characters when using a wildcard.


Search tools

  1. Searching for a string

    • By using the term "Paul West" (including the speech marks) you are asking Donorfy to search for that string, across the profile.It's a good way of searching by first and last name.

    • Without the speech marks (just Paul West) Donorfy would return constituents with Paul and West anywhere in their profile. For example someone called Paul who lives in West Street.

  2. Using OR

    • If you want to find records containing any of the words in your search term. Use OR e.g. Frank OR Smith.

  3. Wildcards

    • Find everything starting with a letter/s using a wildcard search: e.g. Sm*.

  4. Excluding using NOT

    • Use NOT to exclude constituents if they include a word e.g. Smith NOT Frank.

  5. Using brackets to group search terms

    • You can build more complex searches using brackets e.g.("Frank Smith") OR ("Jane Brown").

    • Or ("Frank Smith") AND (("Jane Brown") OR (Mark Jones")).


Filtering the results

Once you have your search results, you may want to filter them:

mceclip4.png

Did this answer your question?