Hi, I'm a new learner and did search the forum and web but can't find straight answers to this.

I have a portal from a related table. Now I duplicate the port to make 3 single-row portals, and I want to show the first row in the first single-row portal, the 2nd row in the 2nd single-row portal, and so on...

I create a calculation field using get(recordnumber) to dynamically general row number.

I try to use portal filter to do the calculation with row number, but it doesn't work.

I know this is problematic because the portal filtering is performed before sorting records, but I just can't figure out another way to do the trick.

 

So, is it possible to achieve what I want with just portal filtering? Any help would be greatly appreciated!

 

My demo file is attached.

 

SingleRowPortal.zip

no need for filters and calculations.  In the portal setup itself you can specify the starting row.  

Thanks Wim, really appreciate!