Forum Discussion

GaryMcRoberts's avatar
GaryMcRoberts
Qrew Cadet
11 years ago

Concat Multiple Values from Child Records into Single Field in Parent

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.

Relationships
Tables and fields
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    10 years ago
    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.
  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    8 years ago
    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