I'm trying to learn how to concatenate multiple child records into a single field on a report. I have spent a lot of time searching google and the help forums and have come up with nothing. I don't want to use reverse look up because there could be a lot of records I'm returning or only 1. I figured the best way to accomplish this would be JavaScript. Maybe some tutorials on how to implement JavaScript functionality with QuickBase would help.

Like this: Concatenate Children To Parenthttps://haversineconsulting.quickbase.com/db/bkgzxdr6t?a=q&qid=1 Pastie Databasehttps://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=463

UPDATED NEW AND IMPROVED: I have updated this example with more generic code where all the parameters are floated to the top and a template is used to define how to summarize child records to the parent field in the report (and I am not through refactoring yet): //parameters: var dbid = "bkgzxdr4x"; var dbidParents = "bkgzxdr6t"; var dbidChilds = "bkgzxfptb"; var apptoken = "q2aznmd9h7eymbwavpzjbsc8hcf"; var n = 100; var relatedParentFid = "7"; var relatedParentLabel = "related_parent"; var clist = "3.7.10"; var qbuClass = "QBU_Childs"; var template = "<ul>{{#.}}<li>{{comment}}</li>{{/.}}</ul>"; Concatenate Children To Parent ~ ListAll2https://haversineconsulting.quickbase.com/db/bkgzxdr6t?a=q&qid=5 Pastie Databasehttps://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=464 More to come ...

Good Morning Everyone At the risk of sounding silly I have a question This code does exactly what I need, I created a code page called concatenate.js but I do not know how to call it within the application, in the demo the data appeared in a field called childs is this done with the image onload technique? or am I missing something really obvious. Many thanks paul

Yes it uses the IOL technique. To implement follow the link in the pastie for step by step instructions.

Trying to implement and can get an alert to show up, but not the concat code to show up. I updated all variables. I didn't put in underscores in field names since I don't use them. I changed field FIDs to 3.6.9. But can't get anything to load. Any help?

How to use JavaScript to concat child records into a single field?

VivekVishwanat3
Qrew Cadet
7 years ago
HI,
I'm getting this text in the Childs field of the "Parents" table.

<img qbu='module' src='/i/clear2x2.gif' onload="javascript:if(typeof QBU=='undefined'){QBU={};$.getScript(gReqAppDBID+'?a=dbpage&pagename=module.js&rand='+new Date().getTime())};"><div class=QBU_Childs data-rid=1></div>

What is the thing that I missed. please Help. (I updated the Variables in the .js file )
- _anomDiebolt_
  Qrew Elite
  7 years ago
  The field needs to be a Rich Text Formula field. You have a Text Formula field currently.
- VivekVishwanat3
  Qrew Cadet
  7 years ago
  I tried with Rich Formula Text Field. but I'm not successful.
  I'm getting result as
- _anomDiebolt_
  Qrew Elite
  7 years ago
  The code is generating two <li> bullets.
  
  More than likely you have not set the parameters correctly for your application. These parameters are from my demo application:
  
  //parameters:
  var dbid = "bkgzxdr4x";
  var dbidParents = "bkgzxdr6t";
  var dbidChilds = "bkgzxfptb";
  var apptoken = "q2aznmd9h7eymbwavpzjbsc8hcf";
  var n = 100;
  var relatedParentFid = "7";
  var relatedParentLabel = "related_parent";
  var clist = "3.7.10";
  var qbuClass = "QBU_Childs";

Forum Discussion

How to use JavaScript to concat child records into a single field?