You can narrow your search to specific (or multiple!) columns. Click the magnifying glass icon next to a column header, then enter your search term(s) in the fields below each column.

• Column search is only available in Grid Layout, not List Layout.
• By default, column-based searches are "starts with" searches, meaning that they only look for matches with the beginning of the specific columns.
• You can search for anything that displays in the column (a "contains" search) by including an asterisk (*) for a wildcard search. For example, searching for Anders*n would return results of both Anderson and Andersen.
• Columns for "Yes" or "No" fields include the option to filter on "Yes," "No," or "Unset". Unset means that no filter is set and fields containing both Yes and No will display. Unset does not mean the value is null.
• Typing "Null" or "Not Null" into a column and pressing enter returns all records where the field is either null or not null. Note: Your capitalization doesn't matter, but if you're searching for someone named Null or with Null in their address, be sure to search for "nul" or "nul*" because searching for "Null" will return null fields rather than people name Null.
• If you're searching for a date, make sure you include the leading 0 for the months January (01) through September (09). Remember: Search for what you see!

When you are finished with your column-based search, you can hide the column search fields by clicking the X on the column header. Otherwise, the column search will remain open for any page you navigate to.

Alternate Column-Based Search: Commas

Want to kick-it old school? MinistryPlatform recognizes commas within search criteria as a way to specify columns. If you have column search open, click the X on the column header to close it. This activates the Search bar at the top of the table. Count the number of columns preceding the column you'd like to search, then enter that number of commas followed by your search term.

In this example, you want to search for everyone in the state of Arizona. The State/Region column is the sixth column from the left, so you would enter five commas (representing the five columns preceding the column you want) then "AZ" as the state to search for.

You can also search in multiple columns using commas. For example, you could enter ",Ward,,,,TX" to find everyone in the state of Texas with the first name Ward.