Go to Record/Request/Page
Purpose
Moves to a record or a report page, or displays a find request.
See also
Format
Go to Record/Request/Page [First/Last]
Go to Record/Request/Page [Previous/Next ; Exit after last: On/Off]
Go to Record/Request/Page [With dialog: On/Off ; <formula>]
Options
•First moves to the first record in the file or
found set (Browse mode), displays the first
find request (Find mode), or moves to the first page in a report (Preview mode).
•Last moves to the last record in the file or found set, displays the last find request, or moves to the last page in a report.
•Previous moves to the previous record in the file or found set, displays the previous find request, or moves to the previous page in a report. Exit after last tells FileMaker Pro to stop the script when it reaches the last record in the found set. You can use Exit after last with the Loop script step to exit out of a loop after the last record.
•Next moves to the next record in the file or found set, displays the next find request, or moves to the next page in a report. Exit after last tells FileMaker Pro to exit the script or control structure (like a loop) when it reaches the last record in the found set.
•By Calculation specifies a calculation to determine the desired record number, find request number, or page number. Set With dialog to On to display the number in a dialog box for confirmation.
Compatibility
Where the script step runs | Supported |
FileMaker Pro | Yes |
FileMaker Server | Partial |
FileMaker Go | Yes |
Custom Web Publishing | Partial |
FileMaker WebDirect | Yes |
Runtime solution | Yes |
Originated in
FileMaker Pro 6.0 or earlier
Description
In Browse mode, this script step moves to a record; in Find mode it displays a find request, and in Preview mode it moves to a report page.
Server-side scripts and Customer Web Publishing do not support the By Calculation option.
Example 1
Performs a find, sorts the records, and goes to the first record.
Perform Find [Restore]
Sort Records [Restore; With dialog: Off]
Go to Record/Request/Page [First]
Example 2
Goes to the record number the user enters in the custom dialog box.
Show Custom Dialog ["Enter the record number you want to view."; Invoices::Record Number]
Go to Record/Request/Page [With dialog: Off ; Invoices::Record Number]
Show All Records
Example 3
Loops through records to export files that are in the Container field. Exits the loop if a record has an empty container field.
Set Variable [$PATH; Value: Get ( DocumentsPath ) & Products::Container]
Go to Record/Request/Page [First]
Loop
Exit Loop If [IsEmpty ( Products::Container )]
Export Field Contents [Products::Container; "$PATH"]
Go to Record/Request/Page [Next ; Exit after last: On]
End Loop
Related topics