Column.formula
|
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 |
|
Module |
|
|
Since |
2015.2 |
Syntax
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.