Discussions
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Access Formula field in Suitelet sublist of saved search
Created saved search where result contains following columns
1.amount
2.type
3.number
4.formula text
Above saved search I m trying to access in my suitelet sublist as below,
sublist.addField('tranid','text', 'Number.');
sublist.addField('amount','text', 'Amount');
sublist.addField('type','text', 'Transaction Type');
but how do I access the formula text field in suitelet sublist
I haved tried following
if(results.length>0)
{
var columns = results[0].getAllColumns();
var result = results[0];
for(var i=0; i<columns.length; i++)
{
var column = columns[i];
var label = column.getLabel();
var formula = column.getFormula();
var functionName = column.getFunction();
var value = result.getValue(column);