List of field options

This topic describes the available options when configuring a database's fields.

Name

The name of the field.

Data Type

The type of data that can be stored in the field.

For a complete list of the supported data types, see List of data types.

Nullable

If true, the field can contain null (empty) values. If false, the field must always contain a value.

Default Value

If a value isn't provided when creating a record, this value will be used instead.

Some data types have functions for dynamically generating default values. For example, if the Data Type is DateTime, the following functions are available:

  • {datetime.now}
  • {datetime.utcnow}
  • {datetime.now.addDays()}
  • {datetime.utcnow.addDays()}

These functions appear while focusing on the Default Value field.

Note: This option is only available if Nullable is disabled.

Min Value

If the data type of the field is a number, such as an Integer or Decimal, this option determines the smallest allowed value in the field.

If the data type of the field is a String, this option determines the minimum length of the string.

Max Value

If the data type of the field is a number, such as an Integer or Decimal, this option determines the largest allowed value in the field.

If the data type of the field is a String, this option determines the maximum length of the string.

Reg Value

A regular expression for validating data entered into the field. This option is only available when the Data Type of the field is String.

Reference

The name of a database table. This option is only available when the Data Type* of the field is Reference* . To learn more, see Creating relationships.