Searching…
If a user navigates to a portal without selecting a specific portal row and without making an object active within a specific portal row, Get (ActivePortalRowNumber) returns row 0 rather than row 1.
Jul 22, 2025 · An unstored calculation of Get (RecordNumber) returns different results in different contexts: the same record may be the 7th in the current found set, but it could be the 5th in a portal, and the 3rd i...
Nov 29, 2016 · Function definition: (Copy & paste into FileMaker's Edit Custom Function window) This calculation will display which portal row a record is based on a Pirmary table and Line items table.
Oct 28, 2013 · How do I determine the portal row number when dragging a document into a container field in FileMaker? Dragging a document into a container field doesn't change focus, so Get (ActivePortalRowNumber)...
Use a script to go to the last portal row and use the Get (portalrownumber) function to get the row number. If your relationship allows creating a new record, I think you might need to subtract 1 from the Get function result.
Apr 2, 2008 · You do not need to use get (portalRowNumber). You can create a field RecordNumber, unstored calc, get (RecordNumber). This will display correctly no matter where the record is. If it is in a portal, it w...
For example, you could use this in a line item table to determine the portal row number of a given line item from the parent record's context, by setting up a self join using the parent record foriegn key as the match field.
Maybe my question should have been, first, to ask if there is a way to get the portal row number a record is sitting on, regardless of its Active/ not active portal row state.
In A you can show AtoB::total_Count which is what you're after. This applies if the AtoB portal is not filtered; If it is, you should duplicate the portal (thus keeping the filtering), making it 1 row height and placi...
The function "Get ( RecordNumber )" is not a constant, it's ephemeral. It's a display item that only shows up when it's needed on a screen to tell you the relative location of that record for a given found set and sort order.
