All table fields have the following required properties:
type: The type of the field. Valid types are described below.
label: The field label.
And the following optional properties:
required: Default false.
description: Optional field description.
readOnly: Default false.
Each field type might also define additional properties. You can take a look of each schema to learn what properties are allowed for each field type.
trueFalse: Same as boolean, but displays a true/false switch.
yesNo: Same as boolean, but displays a yes/no switch.
integer: Integer from -2147483648 to +2147483647
number: Decimal number. Range is up to 131072 digits before the decimal point and up to 16383 digits after the decimal point.
bigint: Integer from -9223372036854775808 to 9223372036854775807.
smallint: Integer from -32768 to +32767.
money: Numeric with 15, 4 precision. Precision can be overridden by the
longText: Same as textArea
select: Allows to select an item from a predefined list.
Date & Time¶
relationship: Allows to reference a record of another table.
user: Allows to select a user.
group: Allows to select a group.
table: Allows to embed a table into this table.
address: Allows to select country, state, city, and enter address1, address2 and zip code.
phone: Allows to select country code, and enter phone number and extension.
file: Allows to upload a file.
image: Allows to upload and crop an image.
signature: Allows to add a signature.
To learn more about specific properties for each type, check out the table fields reference documentation.