Skip to main content
Version: 4.8.0

IntegerColumn

A Column for an integer type field.

Signature​

IntegerColumn(config)

Parameters​

config​

C & IntegerColumnType<TChoices, Type, Default, Dropdown>

Properties:

  • active (optional): boolean Indicates whether to display the field in list and forms

  • array (optional): boolean Creates another table to store the info that will be captured by this field

  • attributes (optional): Record<string, string | number | boolean> Pairs of any supported dictionary attributes (sys_schema_attribute)

  • audit (optional): boolean Indicates whether to track the creation, update, and deletion of all records in the table.

  • choices (optional): Record<string | number, string | ChoiceConfig> Choice values for this field. Keys are the stored values; values are either a display label string or a ChoiceConfig object.

    ChoiceConfig properties:

    • label (required): string — Display label shown in the UI
    • sequence (optional): number — Sort order for the choice
    • hint (optional): string — Tooltip hint
    • inactive (optional): boolean — Hides the choice from the selection list
    • language (optional): string — Language code for the label
    • dependentValue (optional): string | number — Only show when the dependent field equals this value
    • inactiveOnUpdate (optional): boolean — Makes the choice inactive after selection

  • default (optional): Default | string Default value of the field when creating a record

  • dependent (optional): string limit the values available to select based on the value of the dependent field

  • dropdown (optional): Dropdown | choiceDropdownType

  • dynamicValueDefinitions (optional): DynamicValueDefinitions<ReferenceSchema> Object literal, specify type and then relevant additional parameters for reference choices and script defaults

  • elementReference (optional): boolean Indicates if the value of this field connotes the "element type"

  • functionDefinition (optional): string Definition of a function that the field performs

  • help (optional): string Help information for the field

  • hint (optional): string Describes field in more verbose form

  • label (optional): string | Documentation[] Unique label for the column that appears on list headers and form fields

  • mandatory (optional): boolean Indicates whether the field must contain a value to save a record

  • max (optional): number

  • maxLength (optional): number | string Maximum length of the field value

  • min (optional): number

  • plural (optional): string Plural form of the field name

  • primary (optional): boolean Indicates the primary key for a table

  • readOnly (optional): boolean Indicates whether you can edit the field value

  • readOnlyOption (optional): readOnlyOptionType Specifies the read-only behavior for the field

  • spellCheck (optional): boolean Enables spell check for this field

  • tableReference (optional): boolean Indicates if the value of this field is a reference to another table in the schema

  • textIndex (optional): boolean Enables a natural language search on this field

  • unique (optional): boolean Creates a unique index on this field

  • widget (optional): string Style for the element type such as "radio"

  • xmlView (optional): boolean Displays the field value as XML

  • formula (optional): string Formula script for a formula-type virtual field. Sets virtual=true and virtual_type='formula'. Mutually exclusive with dynamicValueDefinitions of type 'calculated_value', which uses virtual_type='script'.

  • virtualType (optional): 'script' | 'formula' Specifies the type of virtual/calculated field. Derived automatically: 'formula' when formula is set, 'script' when dynamicValueDefinitions type is 'calculated_value'. Only set explicitly to override.

See​