Forum Discussion

JustinJustin1's avatar
JustinJustin1
Qrew Member
10 years ago

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

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 w...
APIs and custom code
NotificationsEmail
Relationships
KrissyKrissy's avatar
KrissyKrissy
Qrew Cadet
8 years ago
Hi Dan, or whoever else can help.  I've been trying to get this to work and all I'm getting are the listed dots.   So it's giving me the correct total number of dots for the exact total number of records but it is not returning the field values.  Any suggestions on what we could be doing wrong?
  • TaylorDavis's avatar
    TaylorDavis
    Qrew Member
    7 years ago
    A little late, but better than never...

    To answer your question (and Vivek's below), the parameter that needs to be modified is actually here:
     var template = "<ul>{{#.}}<li>{{comment}}</li>{{/.}}</ul>";  

    You'll want to change "comment" to the Field Label of the target field in your child table. You'll notice in the demo that Dan is querying for values in a field called "Comment"

    And for those asking: yes, you need to write your field labels in lower case with underscores instead of spaces.