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

```columns:
   [
      search.createColumn({name: "tranid", label: "INV#"}),
      search.createColumn({name: "entity", label: "Name"}),
      search.createColumn({name: "otherrefnum", label: "PO Number"}),
      search.createColumn({name: "statusref", label: "Status"}),
      search.createColumn({name: "duedate", label: "Due Date"}),
      search.createColumn({
         name: "formulatext",
         formula: "TO_CHAR({amount},'$999,999,999,999.99')",
         label: "Amount"
      }),
      search.createColumn({
         name: "formulatext",
         formula: "CASE WHEN {customer.parent} = {entity} THEN 'No' ELSE 'Yes' END",
         label: "Formula (Text)"
      })
   ]```

put the object in the getValue call or use the column index

```var form1 = result.getValue({
         name: "formulatext",
         formula: "TO_CHAR({amount},'$999,999,999,999.99')",
         label: "Amount"
      });
var form2 = result.getValue({
         name: "formulatext",
         formula: "CASE WHEN {customer.parent} = {entity} THEN 'No' ELSE 'Yes' END",
         label: "Formula (Text)"
      });```
or
`var form1 = result.getValue(result.columns[5]);`