Skip links

Finding in FileMaker: The right search is half the battle.

FileMaker training, courses, coaching

Finding and selecting records in FileMaker ProFrom the user's point of view, operating a database system such as FileMaker is basically the same as operating a search engine: only those who know the selection options will reach their destination quickly and find the data they are looking for in a matter of seconds. However, mastering the search options is not only important for finding data - with the correct use of the search options, practically any desired selection of data within a FileMaker database can be made.Database for example, to send serial letters to a specific target group or to manipulate data within a specific selection.

Finding and selecting records in FileMaker Pro

When navigating in a FileMaker database and entering or changing data, the user is in browse mode. FileMaker distinguishes between four modes, which can be changed in the menu bar under "View".

  1. Browse mode for navigating and editing data records
  2. Search mode to find or select data records
  3. Layout mode to change the currently selected layout
  4. Side view mode shows how the currently called layout would look on a page or as print output

To find or select data records in FileMaker, the Search mode via the menu bar or the key combination [Cmd-F] or [Ctrl-F] under Windows. The fields now appear with a dashed frame, which indicates to the user that they are in Find mode. FileMaker supports searching in any field, i.e. selections can be made across all fields on the layout.

FileMaker Training and Coaching
Display

Multiple queries for multiple options with the same criteria

The key combination [Cmd-N] or the menu command [Records > New query] can be used to create another query for the current search query. This is necessary if several options are to be selected from the same criteria. For example, if you have a field that contains the entries "Customer", "Supplier", "Prospective customer" and "Trade fair visitor", but you only want to select the customers and suppliers, create your first search query for the customers and the second search query with the suppliers and select the customers in the field in the first query and the suppliers in the second query. Both queries are now carried out in the search result and the respective search results are added to the data records called up afterwards.

In the following overview you will find a list of the search options in FileMaker fields:

Search in text fields

Search for text or text passages in text fields. Unless you are searching for word combinations and exact matches, the field found may contain not only the specified text, but other values in any order. For example, if you enter "Hotel" in the "Company" field, FileMaker will find records for "Hotel", "Wellness Hotel" and "Hotel & Restaurant".

Words that begin with certain characters:

Chris Meyer

...finds Chris Meyer, Chris Meyerdierks and Meyer Christiane.

An exact phrase or character string

"Restaurant Strohhalm"

...finds only "Restaurant Strohhalm"

Words with an unknown sign:

F@au

...finds woman and flat.

Invalid characters

? (question mark)

...finds invalid characters, even in a date or number field

Several unknown characters:

eggs

...finds iron, ice skating and ironworkers.

Digits in a text field

# (for each digit)

...finds 5, but not 50

Parts of a phrase (a string of words or characters):

*"er & Schmidt"

...finds "Meyer & Schmidt", but also "Müller & Schmidt".

Exact match:

== (two equal signs)

==Stefanie

...finds Stefanie, but not Stefanie Meyer.

Exact match with the given whole words:

= (an equals sign)

=Annett =Meyer

...finds Annett Meyer or Meyer Annett, but not Annett or Annette Meyer.

Search in number and date fields

A number in a number field

0,50

...finds 0.50 and 50%.

A value range in a number field

8...50

...finds all values between 8 and 50.

A date in a date field

3.3.2005

...takes place 3.3.2005, March 3, 2005 and 03-03.2005.

A time period in a date field

3.3.2011...31.12.2011

...finds all data records with a date between 3.3.2011 and 31.12.2011.

Today's date in a date field

// (two dashes)

...finds today's (system) date

Date values on a specific day of the week in a date field

Tuesday

...finds all entries that fall on a Tuesday

All valid values for a date or time field

* (asterisk) ...finds all valid values

Invalid dates

? (question mark)

...finds invalid entries, see above

All of the above search options can be used in time or time stamp fields in the same way as the date fields.

Almost all desired search queries and selections can be carried out successfully with the search options mentioned. While the search mode is active, there are further practical commands for working in search mode in the menu bar. In addition to creating new queries, queries can be duplicated or removed here, the search process can be started and result sets can be restricted or expanded. The status bar contains a [none] button that can be used to negate the current search query. It also contains a pop-up menu with special characters frequently used for search queries.

Leave a comment

Share this page:

ERP software as flexible as your company.
We will be happy to advise you.

Customizable ERP software for Mac, Windows and iOS.

You are here: How to find and select records in FileMaker Pro