Perform Find
 
Purpose 
Finds records using find requests stored with the script step.
See also 
Making a find request
Creating scripts to automate tasks
Format 
Perform Find [Restore]
Options 
The Specify find requests dialog box allows you to create and manage find requests. The requests you create are stored with the script step. For more information, see Specify Find Requests and Edit Find Request dialog boxes.
 •
New opens the Edit Find Request dialog box, where you define criteria for a find request.
 •
Edit opens a selected find request from the list.
 •
Duplicate duplicates one or more selected find requests from the list.
 •
Delete deletes one or more selected find requests from the list.
The Edit Find Request dialog box allows you to create or edit find request criteria.
 •
For Action, select Find Records or Omit Records to specify whether this find request will find or omit records. Finding records adds them to your found set. Omitting records excludes them. An individual request can find or omit records; use multiple requests if you need to find and omit records during the same Perform Find script step.
 •
Find records when (or Omit records when) shows a list of the fields in your current table. To construct a find request, begin by selecting a field from this list.
 •
To select a field from a related table, click the name of the current table at the top of the list and select the related table you want. Select a related field from this new list.
 •
Change the value in Repetition to specify a particular cell of a repeating field.
 •
Type your search criteria for the selected field in the Criteria area.
 •
Click Insert Operator to further refine your search criteria. See Finding records.
 •
Click Add to add your criteria to the find request.
 •
To change existing criteria, select the line containing the field and criteria from the top of the dialog box, and make your changes to field and/or criteria. Click Change to store your changes.
 •
To delete existing criteria, select the line containing the field and criteria from the top of the dialog box and click Remove.
Compatibility 
 
Where the script step runs 
Supported 
FileMaker Pro 
Yes 
FileMaker Server scheduled script 
Yes 
FileMaker Go 
Yes 
Custom Web Publishing 
Yes 
FileMaker WebDirect 
Yes 
Runtime solution 
Yes 
Originated in 
FileMaker Pro 6.0 or earlier
Description 
This script step enters Find mode and finds records that match one or more find requests that you set up, that are stored with the script step. If you do not create a find request, this script step will perform the last find request that was executed.
You can use a Perform Find script following an Enter Find Mode script step, to pause the script and allow the user to enter find criteria before performing a find.
Example 1 
Goes to the Invoice Details layout, enters Find mode, pauses for user input, performs a find, and returns to the original layout.
Go to Layout ["Invoice Details"]
Enter Find Mode [Pause]
Perform Find [ ]
Go to Layout [original layout]
Example 2 
Goes to Find mode, pauses for user input, and performs the find. Displays the Invoice Details layout, Invoices layout, or a custom dialog depending on how many records were found.
Set Error Capture [On]
Enter Find Mode [Pause]
Perform Find [ ]
If [Get ( FoundCount ) = 1]
Go to Layout ["Invoice Details"]
Else If [Get ( FoundCount ) > 1]
Go to Layout ["Invoices"]
Else
Show Custom Dialog ["No records were found."]
End If
Related topics 
Constrain Found Set script step
Extend Found Set script step
Finding ranges of information
Script steps reference (alphabetical list)
Script steps reference (category list)
Was this topic helpful? Send feedback.