Help

FILEMAKER PRO HELP 1289
• Variables in a find request can’t include additional variables. FileMaker Pro might not find
matching records accurately if variables are nested.
• Because the value of a variable might be unknown during the validation of a field’s find
request, validation stops when FileMaker
Pro detects a variable. For example, when you
enter find criteria for a date field in the Edit Find Request dialog box, FileMaker
Pro stops
validating the request when you enter the $ symbol (indicating a variable).
• If a find request contains a variable that FileMaker Pro doesn’t recognize, the variable is not
evaluated, and no matching records are found.
• Use either a slash (/) or colon (:) as the terminator character in a variable used in a file path.
Example
The following table shows how criteria can be used to return certain records. Assume that six
records have been entered into a text field called FirstName: Anne, Andrew, Lando5, Han, Han,
Susan.
Note For a list of operators that can be used to find text, see Finding text and characters.
Related topics
Enter Find Mode script step
Perform Find script step
Extend Found Set script step
Constrain Found Set script step
Finding text and characters
Using variables
Specify Script dialog box
Use this dialog box to choose a script to perform in a file that is called by the Perform Script script
step, the Perform Script On Server script step, or a script trigger.
This dialog box also appears in FileMaker Pro Advanced when you customize a menu item to
perform a script.
To specify a script to perform in a file:
1. Select the current file or another specified file (data source) from the list.
2. Select a script from the list.
Action Criteria Record(s) Returned
Find Records Table::FirstName: [==”Andrew”] Andrew
Find Records Table::FirstName: [*an] Han, Han, Susan
Find Records Table::FirstName: [@an] Han, Han
Find Records Table::FirstName: [!] Han, Han
Find Records Table::FirstName: [@an*] Lando5, Han, Han
Find Records
Omit Records
Table::FirstName: [*e*]
Table::FirstName: [*w*] Anne
Find Records
Omit Records
Table::FirstName: [*an*]
Table::FirstName: [*#] Anne, Andrew, Han, Han, Susan