To show single portal row ... confused.

[BlueMount]

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

[Wim Decorte]

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

[BlueMount]

Thanks Wim, really appreciate!