Discussions

Expand all | Collapse all

Concat Multiple Values from Child Records into Single Field in Parent

  • 1.  Concat Multiple Values from Child Records into Single Field in Parent

    Posted 03-05-2015 17:58

    I want to be able to take multiple values from field SOMETHING from many records in my Child table and store in a single field SOMETHINGS in my Parent table.

    For example in the Child I may have the following:

    Record#1 - SOMETHING = A

    Record#2 - SOMETHING = B

    Record#4 - SOMETHING = C

    etc....

    Then in my Parent table my SOMETHINGS field would read A,B,C etc...

    I know I can do this with lookup fields however my SOMETHING field could have over 500 different values in different records and so this would take a lot of lookup fields.

    I am looking for an easier way to do this, maybe using Dan Diebolts Image Onload Technique?

    Any help will be greatly appreciated.



  • 2.  RE: Concat Multiple Values from Child Records into Single Field in Parent

    Silver
    Contributor
    Posted 04-18-2015 14:17
    I do not see any native solution to this; you would likely need some custom programming to populate a field with the value; but you would probably need to invoke the code somehow; or schedule it to run as I doubt it would be dynamic.

    You can "view" this data from within a parent-record by use of a Report Link field. Then build a custom-report which shows all the child-table records with only the [Something] field visible. The downside to this is that you would need to be inside the record; and if you had 500 children, you would have pages and pages of records to click through.


  • 3.  RE: Concat Multiple Values from Child Records into Single Field in Parent

    Silver
    Contributor
    Posted 05-24-2017 05:43
    Hi,

    If you are looking for the same solution like this?



    If yes then, IOL king Dan had posted this solution one year back which exactly looks like as you want.

    https://community.quickbase.com/quickbase/topics/how-to-use-javascript-to-concat-child-records-into-...

    Please have a look at the solution and let me know if it works for you or needs any help.

    Apologies, I am posting this thing after a long time but maybe you or someone is looking for the same thing.

    Thanks,

    Gaurav Sharma