Concat Multiple Values from Child Records into Single Field in Parent

  • 0
  • 2
  • Question
  • Updated 2 years ago
  • Answered

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.

Photo of gmcroberts

gmcroberts

  • 180 Points 100 badge 2x thumb

Posted 4 years ago

  • 0
  • 2
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,208 Points 4k badge 2x thumb
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.
Photo of Gaurav Sharma

Gaurav Sharma

  • 6,024 Points 5k badge 2x thumb
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