Forum Discussion

DanPark1's avatar
DanPark1
Qrew Cadet
7 years ago

Parent Record with Summary fields of multiple Children

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.
Relationships
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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.