title: Populate Suitelet Sublist from a Saved Search with Formulas in the Search
body: <p>@bknights posted an good answer to another question around populating a sublist in a suitelet.</p>
  
  <p>However, my question follows on from that when using bk's code:</p>
  
  <pre><code>function getJoinedName(col) {
      var join = col.getJoin();
      return join ? col.getName() + '__' + join : col.getName();
  }
  searchResults[0].getAllColumns().forEach(function(col) {
      sublist.addField(getJoinedName(col), 'text', col.getLabel());
      nlapiLogExecution('DEBUG', 'Column Label', col.getLabel());
  });
  var resolvedJoins = searchResults.map(function(sr) {
      var ret = {
          id: sr.getId()
      };
      sr.getAllColumns().forEach(function(col) {
          ret[getJoinedName(col)] = sr.getText(col) || sr.getValue(col);
      });
      return ret;
  });
  sublist.setLineItemValues(resolvedJoins);
  </code></pre>
  
  <p>The above works with a standard search with no formulae... How can we do this when I have multiple search columns which are formulae?</p>
  
  <p>Using API1.0</p>