Portal Go to Row and Delete Row

Intermediate

Use Go to Portal Row and Delete Portal Row script steps to programmatically navigate, select, and manage portal records without entering individual record contexts.

What you'll learn

How Go to Portal Row positions focus within a portal
How to loop through all portal rows in a script
How Delete Portal Row works and its prerequisites
How to use Get(PortalRowNumber) and Get(TotalPortalRowCount) in loops

Scripts that manipulate portal data need specific steps for navigating to a portal, selecting a row, and operating on it. Go to Portal Row moves focus to a specific row. Delete Portal Row removes the current row. These steps, combined with loops, let you process all portal rows in a script without navigating away from the parent layout.

1/4

Go to Portal Row

Go to Portal Row moves the active focus to a specific row in a named portal. Options: First, Last, Previous, Next, or by row number. The portal object must have a name set in Inspector for this step to work reliably.

FileMaker Script

// Go to Portal Row step options:
// First          -> positions focus at row 1
// Last           -> positions focus at the last row
// Previous       -> moves back one row
// Next           -> moves forward one row (wraps if at last row by default)
// By row number  -> go to a specific row number (calculated)

// Portal must be named: Portal Object Name = "portal_Invoices"
Go to Portal Row [ portal_Invoices ; First ]
Go to Portal Row [ portal_Invoices ; 3 ]    // go to row 3

Portals: Advanced Configuration Nested Popovers