How to Number Rows in a Portal?

[rlinsurf]

Does anyone know how to number rows in a Portal?

Thanks!

Jeffrey Ellis

[Chuck]

It wouldn't be too hard with a script. You could use something like this:

Set Field [ gPortal_Number, 1 ]

Go to Portal Row [ First ]

Loop

Set Field [ Portal_Number, gPortal_Number ]

Set Field [ gPortal_Number, gPortal_Number + 1 ]

Go to Portal Row [ Next Exit After Last ]

End Loop

If you have your portal allow the creation of related records by typing in a blank portal, you will probably want to add a line to the script just before the End Loop:

Exit Loop If [ IsEmpty( File::Record_ID ) ]

Where Record_ID is a field in the related file that would definately have an entry if there is a record for that portal row. Otherwise, you'll end up creating related records into infinity.

Chuck

[Vaughan]

I've done similar things with summary fields (set as running count). This makes them dynamic and they don't need a script to generate.

[Jamie Tougas]

Status (CurrentPortalRow) Function