Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
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);