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
  • 0
  • 1
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
2 years ago
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?
2 years ago
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!
  • 0
  • 1

Powered by Get Satisfaction