This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

how to retrieve formula text field value in the script, formula text is in columns section

Assuming this is 2.0...
```var mySearch = search.load({
    id: 'customsearch_my_so_search'
  });

    var resultSet = mySearch.run();
    var firstResult = resultSet.getRange({
      start: 0,
      end: 1
    })[0];

    // get the value of the second column (zero-based index)
    var value = firstResult.getValue(resultSet.columns[1]);

    log.debug({
        title: 'Value:',
        details: value
    });```

the `result.getValue()` call is overloaded to accept either the id of the column or the index from the columns array