Go to Portal Row
Purpose
Navigates among the rows in the active portal.
See also
Format
Go to Portal Row [Select: On/Off ; First/Last]
Go to Portal Row [Select: On/Off ; Previous/Next ; Exit after last: On/Off]
Go to Portal Row [Select: On/Off ; With dialog: On/Off ; <formula>]
Options
•Select entire contents selects the entire
portal row. If select entire contents isn’t selected, only one related field in the portal is active.
•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 confirmed in a dialog box if you set With dialog to On.
Compatibility
Where the script step runs | Supported |
FileMaker Pro | Yes |
FileMaker Server | 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, then
Go to Portal Row [Select: Off ; Next ; Exit after last: Off]
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.
•Server-side 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 [Select: Off ; Last]
Example 2
Allows a user to make batch updates to the Status field in a portal.
Go to Portal Row [Select: On ; First]
Loop
Go to Field [Select/perform; Invoices::Status]
Pause/Resume Script [Indefinitely]
Go to Portal Row [Select: Off ; Next ; Exit after last: On]
End Loop
Related topics