Expand all | Collapse all

Record ID of the 2nd child record

  • 1.  Record ID of the 2nd child record

    Posted 09-25-2020 14:43

    Request in the title. Use Case:

    I want to push data from up to 5 child records, to the parent, to specifically mapped fields based on when they were created (i.e. on the parent record, there will be fields called Child 1 Name, Child 1 Value, Child 2 Name, Child 2 Value which would pull data from a relationship). I'm having difficulty coming up with a nice way to do this relationship.

    Any thoughts?


  • 2.  RE: Record ID of the 2nd child record

    Posted 09-25-2020 15:47
    Can you live with an alphabetical sequence for Child 1, Child 2 Child 3?

    So then the easiest way is to make a combined text summary field of the children  and then use a formula field to parse out the parts of that combined text summary field.

    The formula for example for Child 2 will be

    Trim(Part(ToText([Combined Text Summary field]),2,";")) 

    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach