workbook.ConstantType

Note:

The content in this help topic applies to SuiteScript 2.x.

Note:

JavaScript does not include an enumeration type. The SuiteScript 2.0 documentation uses the term enumeration (or enum) to describe a plain JavaScript object with a flat, map-like structure. In this object, each key points to a read-only string value.

Enum Description	Holds string values for constant types. Used to pass the type value to workbook.createConstant(options).
Module	N/workbook Module
Sibling Module Members	N/workbook Module Members
Since	2020.2

Values

Value
BOOLEAN
CURRENCY
DATE
DATE_TIME
DECIMAL
DURATION
INTEGER
NUMBER
RANGE
RECORD
TEXT

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/workbook Module Script Samples.

            // Add additional code
...
var myBooleanConstant = workbook.createConstant({
    constant: true,
    type: workbook.ConstantType.BOOLEAN
});

var myCurrencyConstant = workbook.createConstant({
    constant: 'USD',
    type: workbook.ConstantType.CURRENCY
});

var myDateConstant = workbook.createConstant({
    constant: Date('7/1/2020'),
    type: workbook.ConstantType.DATE
});

var myDateTimeConstant = workbook.createConstant({
    constant: Date('2015-03-25T12:00:00Z'),
    type: workbook.ConstantType.DATE_TIME
});

var myDurationConstant = workbook.createConstant({
    constant: 15,
    type: workbook.ConstantType.DURATION
});

var myNumberConstant = workbook.createConstant({
    constant: 77,
    type: workbook.ConstantType.NUMBER
});

var myTextConstant = workbook.createConstant({
    constant: 'Sample Text',
    type: workbook.ConstantType.TEXT
});
...
// Add additional code 

          

Related Topics

N/workbook Module

SuiteScript 2.x Modules

SuiteScript 2.x

General Notices