Discussions

Expand all | Collapse all

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

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

    Posted 10-27-2016 17:05

    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!



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

    Top
    Contributor
    Posted 10-30-2016 15:49
    See this thread and the Concatenate Children To Parent demo within:

    https://quickbase-community.intuit.com/questions/1282756


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

    Posted 09-07-2018 10:13
    not able to see this link. Please share


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



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

    Posted 09-07-2018 15:57
    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..


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

    Posted 09-07-2018 15:58
    What would need to change in the pastie code? Thank you Dan


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

    Posted 10-31-2016 23:39
    Is there a reasonable limit to how many children you have for a parent?