Perform Find
Purpose 
Enters Find mode and finds records that match one or more find requests that you set up, that are stored with the script step.
Format 
Perform Find [Restore]
Options 
Select Specify find requests or click Specify 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 
Instant Web Publishing 
Yes 
Runtime solution 
Yes 
Originated in 
FileMaker Pro 6.0 or earlier
Description 
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.
Examples 
If FileMaker Pro doesn't find any records that match the find criteria when you perform the script, you can stop the script, continue the script with zero records in the current found set, or change the find criteria. By using the Set Error Capture script step and the Get(LastError) function, you can set up a script to handle such situations. For example:
The following script tries to perform a find. If no records are found, a custom dialog will appear giving the user the option to modify the find request or go back to Browse mode.
Set Error Capture [On]
Perform Find [Restore]
If [Get (LastError) > 0]
Show Custom Dialog ["No records were found. Click OK to modify
your request or click Cancel to return to Browse mode."]
If [Get (LastMessageChoice) = 1]
Modify Last Find
Else
Enter Browse Mode []
End If
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.