Select Specify target field or click
Specify, select a field or specify a calculation indicating the field you want to search by, and click
OK.
If you do not specify a field, FileMaker Pro searches based on the contents of the field that is active when the script runs. If data is selected in the active field, FileMaker Pro searches for the selected data. If data is not selected, FileMaker Pro searches for the entire contents of the active field. If you do not specify a field and there is no active field when the script runs, FileMaker Pro displays an invalid command alert.
The following script finds all records in the database that contain data values that match data in the active Order Date field. For example, this script might return all records showing orders placed on 10/10/2013.
The following script reduces the current found set to include only records that contain product name data values that match the value in the active field. In this example, if the active field contains the text string “coats,” this script reduces the found set from the example above to include only orders for coats that were placed on 10/10/2013.
The following script adds to the current found set all records in the database that contain data values that match data in the active Product Name field. In this example, if the active field contains the text string “shoes,” this script expands the found set to include orders for coats and shoes placed on 10/10/2013.