Go to Portal Row
Purpose 
Navigates among the rows in the active portal.
Format 
Go to Portal Row [Select; <First/Last/Previous/Next/By calculation>]
Options 
Specify lets you choose from the following options.
 •
First moves to the first row in the portal.
 •
Last moves to the last row in the portal.
 •
Previous moves to the previous row in the portal. Exit after last tells FileMaker Pro to exit the script when it reaches the last portal row. You can use Exit after last within a loop to exit the loop after the last portal row.
 •
Next moves to the next row in the portal. Exit after last tells FileMaker Pro to exit the script when it reaches the last portal row. You can use Exit after last within a loop to exit the loop after the last portal row.
 •
By Calculation moves to the row number that is the result of the calculation you create, or to the row number specified in a dialog.
 •
Select entire contents selects the entire portal row. If select entire contents isn’t selected, only one related field in the portal is active.
Compatibility 
 
Where the script step runs 
Supported 
FileMaker Pro 
Yes 
FileMaker Server scheduled script 
Partial 
FileMaker Go 
Yes 
Custom Web Publishing 
Partial 
FileMaker WebDirect 
Partial 
Runtime solution 
Yes 
Originated in 
FileMaker Pro 6.0 or earlier
Description 
When no portal is active, the script uses the first portal in the layout stacking order.
This script step tries to keep the same related field selected when changing rows. If no field in a portal is selected, the script selects the first related field it can enter.
When a related field in a portal is selected, you can use this step to move to the same field in another portal row. For example, if the third field in the second portal row is selected, Go to Portal Row [Next] goes to the third field in the third portal row.
Notes
 •
In FileMaker WebDirect, the cursor moves next to the specified row, but the row is not selected.
 •
FileMaker Server scheduled scripts and Custom Web Publishing do not support the By Calculation option.
Example 1 
Goes to the last row of a portal to create a record.
Go to Field [Related Invoices::Summary]
Go to Portal Row [Last]
Example 2 
Allows a user to make batch updates to the Status field in a portal.
Go to Portal Row [Select; First]
Loop
Go to Field [Select/perform; Invoices::Status]
Pause/Resume Script [Indefinitely]
Go to Portal Row [Next; Exit after last]
End Loop
Related topics 
Go to Object script step
Script steps reference (alphabetical list)
Script steps reference (category list)
About formulas
Was this topic helpful? Send feedback.