Forum Discussion

GiuseppeMacri's avatar
GiuseppeMacri
Qrew Captain
5 years ago

Record ID of the 2nd child record

Hi,

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?

------------------------------
GMacri
------------------------------
Formulas and functions
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    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
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------