Forum Discussion

KrissyKrissy's avatar
KrissyKrissy
Qrew Cadet
8 years ago

Remove duplicates from Concatenated Child to Parent Field - Involves Javascript

I have a field that is using Dan Diebolt's IOL technique that is Concatenating child fields to the parent record into one combined field.  I would like for this field to remove all duplicates and blan...
APIs and custom code
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
Replace this block of code:
 _.each(childsData, function(item, rid) {
   $("span.QBU_Childs[data-rid=" + rid + "]").html( _.pluck(item, "combined_defects").join("<span style='color:red;'> | </span>") );
 });
with this block of code:
 _.each(childsData, function(item, rid) {
   var markup = _.chain(item)
     .pluck("combined_defects")
     .uniq()
     .value()
     .join("<span style='color:red;'> | </span>")
   $("span.QBU_Childs[data-rid=" + rid + "]").html(markup);
 });
  • KrissyKrissy's avatar
    KrissyKrissy
    Qrew Cadet
    8 years ago
    Worked great!  Thanks so much!!  One other question, no big deal if no easy solution for this but is there a way to get the data from that field to show up on an e-mailed report? For some reason that field comes over blank when I try to e-mail.  I added a formula text field and converted it to text but that didn't do the trick. 
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    8 years ago
    These types of fields contain JavaScript and are are evaluated and displayed in the browser. The displayed values is not the saved value.