How can I get all of the record IDs of the related child records into the parent record?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
ie: parent record has 3 child records with RIDs 1, 2 and 3. I need a field in the parent record that would list these RIDs for a report.

Currently, if I export the field that is used to display the report in QB, the RID of the parent record is exported.
Photo of JEREMY

JEREMY

  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
Is there a practical maximum to the number of health records? Well they're always be a maximum of only three records? Also what format would you like these three record IDs listed, would they be in three separate fields of the parent record?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
Basically its this.

Make a summary maximum field on the left side of the relationship for the Minimum of the [Record ID#]. call it [Child Record ID# 1].

Then look that up down to the child record.

Then a new Summary of the Minimum Record ID#, subject to the condition that the [Record ID#] is grater than the [Child Record ID# 1]. call it [Child Record ID# 2].

Then look that up down to the child record.


Then a new Summary of the Minimum Record ID#, subject to the condition that the [Record ID#] is grater than the [Child Record ID# 2]. call it [Child Record ID# 3].

Y'ur done!