In Quickbase, how do I pull data from multiple rows in a child relationship and catenate their text values into a parent cell? For example, pulling in a list of associated departments (in another table), and having their names displayed like: "qa cs dev it".
Code like this will query a table (child table in your case), return the [name] fields into an array, concatenate the values into a string, and finally stuff the concatenate values into _fid_6 on the form:
var url="https://www.quickbase.com/db/DBID?act=API_DoQuery&query={3.EX.RID}";
$.get(url,function(xml){
var items = $("record name",xml).map(function(){
return [$(this).text()];
}).get().join(" ");
$("#_fid_6").val(items);
});
Okay.
figured out (by chasing down several Google search results) how to do the img onload insertion of the "module.js" link. Thanks for that piece of work. Too bad it isn't more widely shared.
I'll try to get this custom piece of JS inserted into the module.js and see if/how it works.
Ok. I guess I don't understand what "RID" should be. that is, the "3.EX.RID"
And, should I replace "record name", with "record Name", where "Name" is the actual field name, or should I replace "record name" with "Name"?
How do I fetch only related records? That is, records that are linked by the current master record ID being equal to the "Related Apps ID" field in the child table?
Thanks for your help
