Forum Discussion

DanPark1's avatar
DanPark1
Qrew Cadet
6 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 T...
Relationships
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 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.