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.
Updated 8 months ago