How to I pull text data from child table and 'combine' into a single text field at the parent level?

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • Answered

Kind of like a summary field for text. I need this for a report. 

For example - the parent table "jobs" that has 3 services. I want to pull the 3 "service names" into a single field ('service names') for the related "job". I want to combine the names into a single field for easy export. 

Thanks!

Photo of George

George

  • 80 Points 75 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 Points 20k badge 2x thumb
See this thread and the Concatenate Children To Parent demo within:

https://quickbase-community.intuit.com/questions/1282756
not able to see this link. Please share
Photo of George

George

  • 180 Points 100 badge 2x thumb
Dan, if I had a multiple choice field on the child records called [order] -- (multiple choices 1,2,3,4,5,6,7.8,9,10) --  basically when Concatenate Children records To Parent record -- having the ability to determine what order to concatenate....as well as having a checkbox field -- [Exclude] -- having the ability to exclude child records where Exclude is checked..
Photo of George

George

  • 180 Points 100 badge 2x thumb
What would need to change in the pastie code? Thank you Dan
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,358 Points 50k badge 2x thumb
Is there a reasonable limit to how many children you have for a parent?