In this Article: Show

 

Everyday Tools

Using the Find Feature

FrameReady provides multiple, powerful search options.

How to do a Quick Find

Quick Find searches all fields for a match. You may enter a word, phrase, number or date (in MM/DD/YYYY format).

  1. Click the Quick Find icon.
    A dialog screen appears with prompt for search terms.

  2. Type in your search.

  3. Click Search or OK.

How to Perform a General Find

Every file has a Find feature built into it. This allows you to search for records with a common element and can be broadly or narrowly defined as needed, e.g., find all wood moulding, or find all wood moulding that is two inches wide with the word oak in the Description field.

  1. Click Find.

    The Enter Search Criteria screen appears.

  2. Choose fields and type in your search.

  3. Click Perform Find.

If only one item met the search criteria then it will appear in Form View. If more than one item meets the criteria then the List View will appear.

How to Perform a Multiple Find

While in the find mode, you can narrow down your search criteria by selecting additional items. E.g., find all customers who are both photographers and want your newsletter. However, sometimes you want to find all customers who are photographers and all customers who prefer newsletters.

Example One

  1. Go to Contacts file > Find.

  2. Click on the check-box of the first keyword, photographer and then click on the check-box of the second keyword, newsletter.

  3. Click the Perform Find button.

    A list view of all contacts who meet both criteria appears on the screen.

Example Two

  1. Go to Contacts file > Find.

  2. Click on the check-box of the first keyword, photographer.

  3. Choose from the upper menu bar Requests > Add New Request.

  4. Click on the check-box of the second keyword, newsletter.

  5. Click the Perform Find button.
    A list view of all contacts who meet one or the other or both criteria appears on the screen.

How to Enter Values in a Find

Numeric Tool Palette

FileMaker Pro contains a symbol tool palette which can be used when performing a search or Find.

  1. Click into a field, right-click and choose "Operators"

    A context menu of symbols appears.

  2. Make sure your cursor is in the field to which you wish add the symbol. Click on Operators.

    Here is a chart to explain the symbols and show how they can be used in FrameReady.

How to Find Records Except Those Matching Criteria (Omit Find Feature)

You can omit records while performing a find. In other words, you can find information in your database that does not equal your specified criteria. For example, you can find all invoices except those created in the past 30 days.

To find records that don’t match criteria:

  1. In Find mode, type criteria for the records to omit.
    For example, to find all sales records except those for the city of London, type London in the City field.

  2. Click Omit in the layout bar.

  3. Click Perform Find.

To find some records while omitting others:

  1. In Find mode, type the criteria for the records to find.

    For example, to find vendors in the state of New York, except those in the city of Albany, start by typing New York in the State field.

  2. Click the New Request button in the status toolbar.

    If this is not visible, cancel the find, then choose View > Status Toolbar.

  3. Type criteria for the records to exclude, and click Omit.
    To exclude Albany, you would type Albany in the City field and click Omit.

  4. If you wish to do more than one Omit, you must remember to select Add New Request each time before selecting the next item.

  5. Click Perform Find.

Notes about the Omit Feature