Column.formula

Note:

The content in this help topic pertains to SuiteScript 2.0.

Property Description

Formula used for a search column as a string.

To set this value, you must use formulatext, formulanumeric, formuladatetime, formulapercent, or formulacurrency.

Type

string

Supported Script Types

Client and server scripts

For more information, see SuiteScript 2.x Script Types.

Module

N/search Module

Since

2015.2

Syntax

Important:

The following code sample shows the syntax for this member. It is not a functional example. For a complete script example, see N/search Module Script Samples.

For example, in the UI, a field with a custom UI label named Customer Name is set by a formula of type Formula (Text) and the formula is defined with the following formula:

          //Add additional code 
...
var columnObj = search.createColumn({
  name: 'formulatext',
  formula: "{firstname} || ', ' || {lastname}"
});
...
//Add additional code

In the above formula, firstname and lastname are script IDs for the fields on the Customer record form.

Syntax

Related Topics