Go to Record/Request/Page script step

Contents > Script steps reference (alphabetical list) > Navigation script steps > Go to Record/Request/Page script step

Go to Record/Request/Page script step

Format


Go to Record/Request/Page [<first/last/previous/next/by calculation>]

Options

Specify lets you choose from the following options.

First moves to the first record in the file or found set, displays the first find request, or moves to the first page in a report.

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 lets you create a calculation to determine the index number for the desired record, find request, or page in Preview mode.

Note Exit after last will exit a loop but does not stop or exit a script.

Web compatibility

This script step is web-compatible.

Description

In Browse mode, moves to a record in the found set. In Find mode, displays a find request. In Preview mode, moves to a page in a report.

Examples


Go to Record/Request/Page [First]
Go to Record/Request/Page [Last]
Go to Record/Request/Page [Previous]
Go to Record/Request/Page [Next]

This command uses a calculation to determine the correct number:


Go to Record/Request/Page [MyDatabase::Number Field]

Script step categories

About formulas

Contents > Script steps reference (alphabetical list) > Navigation script steps > Go to Record/Request/Page script step