Parent Record with Summary fields of multiple Children

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
I have 2 tables Parent and Child with a 1 to many relationship where Parent can have many children.

I am trying to create summary fields in the Parent record such as

First Child
Second Child
Third Child
Fourth Child
etc..

struggling to make this happen.. 

Any help would be greatly appreciated.
Photo of Dan Park

Dan Park

  • 440 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
I suggest that you first summarize all the children up to the Parent using a Combined Text Summary field.

Then, you are asking how do parse out the individual children teams.

Make a formula text field like this

var text value = ToText([My Combined Text summary field]);

Trim(Part($value,1,";"))

That will be the formula for the first child

Then copy that field and replace 1 with 2 for the 2nd child.