Does anyone know how to number rows in a Portal?

Thanks!

Jeffrey Ellis

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

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.

Status (CurrentPortalRow) Function