Skip to main content

Field

Get the field information in the datasheet

field.Field

Parameters​

id​

• get id(): string

Field id, unique identification of field

Returns​

string

Example​

console.log(myField.id); // => 'fldxxxxxx'

name​

• get name(): string

Field name, different field name is not duplicated

Returns​

string

Example​

console.log(myField.name); // => 'FieldName'

type​

• get type(): FieldType

Field type, the field type is an enumeration value, please refer to FieldType

Returns​

FieldType

Example​

console.log(myField.type); // => 'SingleLineText'

description​

• get description(): null | string

Return the description of the current field

Returns​

null | string

Example​

console.log(myField.description);
// => 'This is my field'

property​

• get property(): IOpenFieldProperty

The configuration property of the field. The structure of the field's property depend on the field's type. Return null if the field has no property. Refer to FieldType.

Returns​

IOpenFieldProperty

FieldType

Example​

console.log(myField.property.symbol); // => '¥'

isComputed​

• get isComputed(): boolean

A field is "computed" if its value is not set by user input.(AutoNumber, Formula, MagicLookUp, LastModifiedTime, CreatedTime, LastModifiedBy, CreatedBy, etc.)

Returns​

boolean

Example​

console.log(mySingleLineTextField.isComputed);
// => false
console.log(myAutoNumberField.isComputed);
// => true

isPrimary​

• get isPrimary(): boolean

Returns whether the current field belongs to the main field. In the datasheet, the main field is always the field where the first field is located.

Returns​

boolean

Example​

console.log(myField.isPrimary); // => true

Methods​

updateDescriptionAsync​

▸ updateDescriptionAsync(description): Promise<void>

Updates the description for this field.

The API will throw an exception message if there is no written permission.

Parameters​

NameTypeDescription
descriptionnull \ string

Returns​

Promise<void>

Example​

 await field.updateDescriptionAsync('this is a new description')

updatePropertyAsync​

▸ updatePropertyAsync(property, options?): Promise<void>

Updates the property for this field, tips: that the update property configuration must be overwritten in full.

If the configuration format is incorrect, or if there is no written permission, the API will throw an exception message.

Refer to FieldType for supported field types, the written format for property, and other specifics for certain field types.

Parameters​

NameTypeDescription
propertyanyNew property for the field.
options?IEffectOptionAllow property that will have secondary effects

Returns​

Promise<void>

Example​

function addOptionToSelectField(selectField, nameForNewOption) {
const updatedOptions = {
options: [
...selectField.options.choices,
{name: nameForNewOption},
]
};

await selectField.updatePropertyAsync(updatedOptions);
}