Sign in to follow this  
Followers 0

Get (ActivePortalRowNumber)

3 posts in this topic

Posted

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.

 

Thanks.

 

 

0

Share this post


Link to post
Share on other sites

Posted

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

Share this post


Link to post
Share on other sites

Posted

Thank You.  That did it.,

0

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