Skip to main content
Question

Parent Record with Summary fields of multiple Children

  • Mar 22, 2019 6:14 PM UTC
  • 0 replies
  • 45 views
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.
    This topic has been closed for replies.

    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.
    Terms & ConditionsAccessibility statement