Hi all

I have written a custom portlet script to give me a list of opportunities, which appears to be giving me the correct results, apart from one slight issue. For the Company and Sales Rep columns in my results, I am being presented with the internal ID rather than the entity number/customer name and the sales rep name. I need the equivalent of a nlapiGetFieldText() API but for this custom portlet.

This is my current script:

 function unqtdOppPortlet(portlet, column)  {  portlet.setTitle("Unquoted Opportunities");  portlet.addColumn('trandate','date', 'Date', 'LEFT');  var col = portlet.addColumn('tranid','text', 'Number', 'LEFT');  col.setURL(nlapiResolveURL('RECORD','opportunity'));  col.addParamToURL('id','id', true);  portlet.addColumn('entity','text', 'Customer', 'LEFT');  portlet.addColumn('custbody_pqc_date','date', 'Date of Pre-quote', 'LEFT');  portlet.addColumn('expectedclosedate','date', 'Expected Close', 'LEFT');  portlet.addColumn('projectedamount','currency', 'Projected Total', 'RIGHT');  portlet.addColumn('custbody_opp_site_adress','text', 'Site Address', 'LEFT');  portlet.addColumn('salesrep','text', 'Sales Rep', 'LEFT');    var returnFilter = new Array();  returnFilter[0] = new nlobjSearchFilter('salesrep',null,'is',29918)    var returncols = new Array();  returncols[0] = new nlobjSearchColumn('trandate');  returncols[1] = new nlobjSearchColumn('tranid');  returncols[2] = new nlobjSearchColumn('entity');  returncols[3] = new nlobjSearchColumn('custbody_pqc_date');  returncols[4] = new nlobjSearchColumn('expectedclosedate');  returncols[5] = new nlobjSearchColumn('projectedamount');  returncols[6] = new nlobjSearchColumn('custbody_opp_site_adress');  returncols[7] = new nlobjSearchColumn('salesrep');    var results = nlapiSearchRecord('opportunity', null, returnFilter, returncols);  for ( var i