Skip to content

Integer

Reference5 minFoundation

Capture a whole-number quantity, such as 12 chairs on a purchase order. The form uses 0 decimal places, so fractional quantities need Decimal.

A whole number.

INT

Use when

  • Purchase order: 12 chairs

Choose another type for

  • Fractional quantities

On a form

A number input with 0 decimal places.

In views

Can be selected for configured data view columns. Spreadsheet editing is offered for own, non-key fields of this type when the column is editable.

In Smart Script

getCurrentValue() has a String return type for every field type; an unset value can be null. Parse with parseInt or parseFloat before arithmetic.

Import and export

Use digits and a decimal point in numeric import cells. Review the analysis preview before confirming. Configure numeric display settings on the field.

Example

Purchase order: 12 chairs

Settings

SettingWhat it does
Show in record detailsIncludes this field in the record details; forms and data views are configured separately.
Show in the record headerIncludes this field among the record header fields.
PositionSets the order in record details; lower numbers appear first.
Virtual fieldComputes the value at display time instead of storing it.
Encrypt valuesChoose encryption when you create the field.
Encryption keySelect an ACTIVE encryption key.
Default valueSets a plain value or Smart Script for new records.
The Integer field configuration and its type-specific settings.

    Name the field

    Section titled “Name the field”

    Start the field name with an English letter. Use letters, digits, spaces and underscores.

    What's next

    Which field type should I use?Choose a field type by what people will enter and what you want to do with it later, from short text and dates to lookups, relations and smart fields.Add a fieldAdd a field to a module so people can capture a new piece of information, such as a contract's end date.

    Last checked