Apply transformer for each row in table - adding new column

[chris-g]

Hi Here is an example where I am using a transformer to add a formatted preview to each object in a collection.

// format message for preview
let nl = "\n";
let sp = " - ";

data.forEach(r => {

  var days =  [r.d1, r.d2, r.d3, r.d4, r.d5, r.d6, r.d7];
  for (let day of days) {
    let overview = "";
    if (day) {
      if (day.status) overview += day.status; 
      if (day.status_info) overview += sp + day.status_info; 

      if (day.message) {
        for (let m of day.message) {
          overview += nl + "id" + sp + m.id + nl
                + "sequence" + sp + m.sequence   + nl
                + "text" + sp + m.text   + nl
                + "link" + sp + m.link   + nl
                + "image_url" + sp + m.image_url; 
        }
      }

    } else {
      day = {};
    }
    day.overview = overview;


  }
  return r;
})

return data;