List Master Help: SEARCH SCREEN

OVERVIEW

Use this screen to create a list of people or organizations. Use the list to send emails, create letters with a Word merge, generate reports, select records to edit, manage your relationships, and much more.

To search: Fill in the appropriate field and hit “Find” (in the upper left-hand corner of the screen) to get your results.

Example: Looking for a donor named Diane Wilkinson? Enter “Wilkinson” in the "Last Name" field, then hit "Find."

You can run a query using multiple fields.

Example: Looking for a donor named Diane Wilkinson who lives in Portland?
Enter “Diane” in the "First Name" field and “Portland” in the "City" field, then hit "Find."

Queries can be saved for future use.

Please note that searching some fields, such as certain transaction fields, will generate reports with contact names listed multiple times. List Master automatically removes these duplicates for broadcast emails, broadcast faxes and mail merges. 

See Searching Tips for additional information.

Searching CONTACT Fields

Quick Find: Use to search by any first name, last name, business name or record number.

Phone: Search for any number — primary phone, work, cell or fax.

Entered from/to/by and Modified from/to/by: Use to locate records that have been entered or modified between certain dates and/or by specific employees or volunteers. Dates must be formatted YYYY-MM-DD.

Query Name: Save frequently used searches here. Enter query information into relevant search fields, and before hitting "Find," give the search a name in the "Query Name" field. Then hit the “Save Query” button.

The Saved Query drop-down menu displays all saved queries for selection and use. Existing queries can be modified and updated. They can also be deleted. Please  note the “Last Search” choice in the menu, which populates the screen with the most recently run query.  

Searching CATEGORY CODE fields

Category Codes: Click for a formatted list of all categories.

Three lines are provided for category searches, each with a drop-down menu for selecting values.

Include: Choose one or more category codes from the drop-down menu at right to generate a comma-separated list of clients fitting any of the selected categories.

And: Use to refine the category code search. Use to identify records that are also in the selected categories.

Example: Choosing category "Board Members" for the "Include" field and "Major Donors" for the "And" field will produce a list of client records that are in BOTH categories.

Exclude: Use to exclude records from the search. Often used to exclude records with certain handling codes.

Example: Choose category "Bad Address" to exclude records with incorrect mailing addresses.

Searching TRANSACTIONS fields

Click Show/Hide Transaction Forms to reveal this section.

This section is used to refine searches by including or excluding transaction information. These sections can be used independently or in conjunction with other sections on this screen.

Dates From/To: Search for or exclude transactions within a chosen date range.

Amounts From/To: Search for or exclude records within a specified amount range.

Totals From/To: Search for client records within a specified cumulative giving amount range.

Member Dates From/To: Generally used for membership expiration dates.


Donation Codes: Search for or exclude client records based on donation codes. Select from the "Donation Codes" drop-down menu at the bottom left of the section.

Appeal Codes: Search for or exclude client records based on appeal codes. "Mailing Appeal Codes & Restricted Use Codes" can be selected from a drop-down menu at the bottom right of the section. The "Appeal & Use Code List" located just above this field can be used with your browser’s find tools to search for codes with certain keywords or phrases.

Use Codes: Search for or exclude client records based on use codes. "Mailing Appeal Codes & Restricted Use Codes" can be selected from a drop-down menu at bottom right of the screen. The "Appeal & Use Code List " located just above this field can be used with your browser’s find tools to search for codes containing certain keywords or phrases.

Entered/Modified By: Search for client records by the date they were entered or modified by a certain person.

Thank-you Batch #: Search for client records by thank-you letter batch number.

Searching CONTACTS fields

Contacts can be queried by type, subject, or date of creation.

Searching NOTES fields

Notes can be queried by result or author. You can also type in keywords to find specific notes or groups of notes.

Searching VOTER/POLITICAL AFFILIATION fields

These fields are an optional add-on for your database. They are located in the top section, under the "E-mail" and "Phone" fields.

Oregon House, Oregon Senate, U.S. Congress fields and Precinct: Entering a district or precinct number in these fields will bring up a list of contacts in those districts/precincts.

Political Party: Search by D, R, I, O or N to generate a list of contacts by political party. 

D = Democrat
R = Republican
I = Independent
O = Other. Use for Socialist, Green, etc.
N = non-affiliated.

Searches in these fields will find only contacts with voter data already associated with their records. Records entered since the most recent voter data load will not be captured.

Exclude: If this box is checked, it negates the entire voter data search.

Example: Entering "D" in the "Political Party" field, "34" in the "Oregon House" field, and checking "Exclude," will find all records containing voter data with the exception of any Democrats in District 34.