Scripting portal row operations

Expert

Create, update, and delete related records through portal rows from scripts, and understand commit behavior in portal context.

What you'll learn

How to navigate to a specific portal row from a script
How to create a new related record via a portal
How to delete a portal row without affecting the parent record

Portals display related records and can be edited directly by users. Scripting the same operations — creating a new portal row, modifying fields in a specific row, deleting rows — requires understanding how FileMaker tracks the "current portal row" and when portal changes are committed.

1/3

Navigate to a portal row

Go to Portal Row navigates to a specific row number within the specified portal. Combined with Go to Field, you can place the cursor in a portal field for editing.

FileMaker Script

# Go to the third row of the LineItems portal
Go to Portal Row [ No dialog ; "LineItems" ; 3 ]
Set Field [ LineItems::Quantity ; 5 ]
Commit Records/Requests [ No dialog ]

Commit and revert patterns in multi-step workflows Allow User Abort and script cancellation control