Table Fields

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.

Field Types

Boolean

  • boolean

  • trueFalse: Same as boolean, but displays a true/false switch.

  • yesNo: Same as boolean, but displays a yes/no switch.

Numeric

  • 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 decimals property.

Strings

  • text

  • textArea

  • longText: Same as textArea

  • password

  • email

  • url

  • uuid

  • select: Allows to select an item from a predefined list.

Date & Time

  • date

  • time

  • datetime

Relationships

  • 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.

Complex Types

  • 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.

See: