Skip to content

Decimal

Reference5 minFoundation

Capture quantities with fractions, such as 12.75 hours on a service invoice. Decimal places controls the displayed precision; Currency adds a currency code to a monetary amount.

A number with configurable decimal places.

DECIMAL

Use when

  • Invoice: 12.75 hours of service

Choose another type for

  • Choosing a currency code

On a form

A number input with a decimal separator and configurable 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

Invoice: 12.75 hours of service

Settings

SettingWhat it does
Decimal placesSets how many decimal places to display.
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.
Field editor drawer for Contract Value: type Decimal, decimal places, shown in record details, record header option, virtual and encrypted options.

    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