Is there a way to identify top row of portals?

Questions
#1

I want to hide a field if it's the top row of a portal, is there some way to identify the top row of a portal? I tried to hide it if "Get (RecordNumber) = 1" but that hides all of them.

#2

Use the field with the primary key to find the first item of the list displayed in the portal. In this example the field is called "id":

Let (
~firstID = LeftValues ( List ( portaltable::id ) ; 1 ) ;
portaltable::id & ¶ = ~firstID
)
2 Likes
#3

Solved. Thank you!

1 Like
#4

I wonder if GetNthRecord would be faster than getting the entire list and then using LeftValues?

Something like this:

Let (
  firstID = GetNthRecord( portaltable::id  ; 1 ) ;
  id = firstID
)
1 Like
#5

the fasted "should be" PortalTable::MyUnstoredRecNum = 1 where
MyUnstoredRecNum := Get ( RecordNumber ) as an unstored calc in the PortalTable

3 Likes
#6

same way (for fast performance) I needed the last portal and I used an unstored number field get(foundcount)) and the condition for hide or whatever is PortalTable::MyUnstoredRecNum =PortalTable::foundcount

1 Like
#7 
Let (
  firstID = GetNthRecord( portaltable::id  ; 1 ) ;
  portaltable::id = firstID
)

This way it works without extra field in the PortalTable. Great!