Record ID of the 2nd child record

Question

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------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community