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

Question

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!

_anomdiebolt_ · Answer

See this thread and the&nbsp;Concatenate Children To Parent&nbsp;demo within: https://quickbase-community.intuit.com/questions/1282756

quickbasecoachd · Answer

Is there a reasonable limit to how many children you have for a parent?

pushpakumargna1 · Answer

not able to see this link. Please share

_anomdiebolt_ · Answer

https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&amp;rid=463

georgegeorge · Answer

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) -- &nbsp;basically when&nbsp;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..

Forum Discussion

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

Related Content

Many parent records on a single child record

Sorting Combined Text Field by Record ID#

View all Parent records and related Child records in single table view

Modify multiple rows within the same group using Single Record ?

Copy Single Table from One App to Another