Sign in to follow this  
Followers 0

Get (ActivePortalRowNumber)

3 posts in this topic

I have a db with over 20k records and I'm introducing a new field to my child table.  Each Parent cant have many childs and for each child I would like to assign a unique number starting with 1.


the goal is to see all my child items the following way.


Parent,  child ID, ActivePortalRowNumber


6294     14785236    1

6294      14785237   2

6295      14785238  1
6296       14785239  1

6296      14785240   2

6296      14785241   3



My current challenge is that I can create a calc to get the active portal row number, but its only going forward.  how can I go back and set the rest of the 20k.





Share this post

Link to post
Share on other sites

That's not really a portal row number …


Anyway, to get this numbering, in the child table create a summary field sCountOf<anyGuaranteedNonEmptyField>; set it to Running Count, with restart when sorted by parentID (from the TO the portal is based on); sort either the relationship or the portal by parentID.


(Note that you could use this field to create a summary effect in the portal, e.g. by giving each parentID where summary field ≠ 1 the text colour of the background colour, or a font size of 500 …)  


OTOH, if you have a portal that shows children for only one parent, you can simply put a record number symbol into the portal row.

1 person likes this

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0