---
title: "GET /api/database/fields/{field_id}/"
method: GET
path: "/api/database/fields/{field_id}/"
tags: ["Database table fields"]
---

# GET /api/database/fields/{field_id}/

`GET /api/database/fields/{field_id}/`

Returns the existing field if the authorized user has access to the related database's workspace. Depending on the type different properties could be returned.

## Path parameters

- `field_id` integer, required

## Response `200`

- union
  - TextFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `text_default` string — If set, this value is going to be added every time a new row created.
  - LongTextFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `long_text_enable_rich_text` boolean, nullable — Enable rich text formatting for the field.
  - URLFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
  - EmailFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
  - NumberFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `number_decimal_places` 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 — * `0` - 1 * `1` - 1.0 * `2` - 1.00 * `3` - 1.000 * `4` - 1.0000 * `5` - 1.00000 * `6` - 1.000000 * `7` - 1.0000000 * `8` - 1.00000000 * `9` - 1.000000000 * `10` - 1.0000000000
    - `number_negative` boolean — Indicates if negative values are allowed.
    - `number_prefix` string
    - `number_suffix` string
    - `number_separator` union — The thousand and decimal separator to use for the field. * `` - No formatting * `SPACE_COMMA` - Space, comma * `SPACE_PERIOD` - Space, period * `COMMA_PERIOD` - Comma, period * `PERIOD_COMMA` - Period, comma
      - 'SPACE_COMMA' | 'SPACE_PERIOD' | 'COMMA_PERIOD' | 'PERIOD_COMMA' — * `` - No formatting * `SPACE_COMMA` - Space, comma * `SPACE_PERIOD` - Space, period * `COMMA_PERIOD` - Comma, period * `PERIOD_COMMA` - Period, comma
      - ''
    - `number_default` string, decimal, nullable — The default value for field if none is provided.
  - RatingFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `max_value` integer — Maximum value the rating can take.
    - `color` string — Color of the symbols.
    - `style` 'star' | 'heart' | 'thumbs-up' | 'flag' | 'smile' — * `star` - Star * `heart` - Heart * `thumbs-up` - Thumbs Up * `flag` - Flag * `smile` - Smile
  - BooleanFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `boolean_default` boolean — The default value for field if none is provided.
  - DateFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `date_format` 'EU' | 'US' | 'ISO' — * `EU` - European (D/M/Y) * `US` - US (M/D/Y) * `ISO` - ISO (Y-M-D)
    - `date_include_time` boolean — Indicates if the field also includes a time.
    - `date_time_format` '24' | '12' — * `24` - 24 hour * `12` - 12 hour
    - `date_show_tzinfo` boolean — Indicates if the timezone should be shown.
    - `date_force_timezone` string, nullable — Force a timezone for the field overriding user profile settings.
  - LastModifiedFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `date_format` 'EU' | 'US' | 'ISO' — * `EU` - European (D/M/Y) * `US` - US (M/D/Y) * `ISO` - ISO (Y-M-D)
    - `date_include_time` boolean — Indicates if the field also includes a time.
    - `date_time_format` '24' | '12' — * `24` - 24 hour * `12` - 12 hour
    - `date_show_tzinfo` boolean — Indicates if the timezone should be shown.
    - `date_force_timezone` string, nullable — Force a timezone for the field overriding user profile settings.
  - LastModifiedByFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `available_collaborators` Collaborator[], required — A list of all the available collaborators.
      - `id` integer, required
      - `name` string, required
  - CreatedOnFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `date_format` 'EU' | 'US' | 'ISO' — * `EU` - European (D/M/Y) * `US` - US (M/D/Y) * `ISO` - ISO (Y-M-D)
    - `date_include_time` boolean — Indicates if the field also includes a time.
    - `date_time_format` '24' | '12' — * `24` - 24 hour * `12` - 12 hour
    - `date_show_tzinfo` boolean — Indicates if the timezone should be shown.
    - `date_force_timezone` string, nullable — Force a timezone for the field overriding user profile settings.
  - CreatedByFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `available_collaborators` Collaborator[], required — A list of all the available collaborators.
      - `id` integer, required
      - `name` string, required
  - DurationFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `duration_format` 'h:mm' | 'h:mm:ss' | 'h:mm:ss.s' | 'h:mm:ss.ss' | 'h:mm:ss.sss' | 'd h' | 'd h:mm' | 'd h:mm:ss' | 'd h mm' | 'd h mm ss' — * `h:mm` - hours:minutes * `h:mm:ss` - hours:minutes:seconds * `h:mm:ss.s` - hours:minutes:seconds:deciseconds * `h:mm:ss.ss` - hours:minutes:seconds:centiseconds * `h:mm:ss.sss` - hours:minutes:seconds:milliseconds * `d h` - days:hours * `d h:mm` - days:hours:minutes * `d h:mm:ss` - days:hours:minutes:seconds * `d h mm` - days:hours:minutes:with_spaces * `d h mm ss` - days:hours:minutes:seconds:with_spaces
  - LinkRowFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `link_row_table_id` integer, nullable — The id of the linked table.
    - `link_row_related_field_id` integer, nullable, required — The id of the related field.
    - `link_row_table` integer, nullable — (Deprecated) The id of the linked table.
    - `link_row_related_field` integer, required — (Deprecated) The id of the related field.
    - `link_row_limit_selection_view_id` integer, nullable — The ID of the view in the related table where row selection must be limited to.
    - `link_row_table_primary_field` string, required — The primary field of the table that is linked to.
    - `link_row_multiple_relationships` boolean — Indicates whether it's allowed set multiple relationships per row. If disabled, it doesn't guarantee single relationships because they could have already existed or created through reversed relationship.
  - FileFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
  - SingleSelectFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `select_options` SelectOption[]
      - `id` integer
      - `value` string, required
      - `color` string, required
    - `single_select_default` integer, nullable
  - MultipleSelectFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `select_options` SelectOption[]
      - `id` integer
      - `value` string, required
      - `color` string, required
    - `multiple_select_default` integer[], nullable
  - PhoneNumberFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
  - FormulaFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `nullable` boolean, required
    - `array_formula_type` union
      - 'invalid' | 'text' | 'char' | 'button' | 'link' | 'date_interval' | 'duration' | 'date' | 'boolean' | 'number' | 'single_select' | 'multiple_select' | 'single_file' | 'url' | 'multiple_collaborators' — * `invalid` - invalid * `text` - text * `char` - char * `button` - button * `link` - link * `date_interval` - date_interval * `duration` - duration * `date` - date * `boolean` - boolean * `number` - number * `single_select` - single_select * `multiple_select` - multiple_select * `single_file` - single_file * `url` - url * `multiple_collaborators` - multiple_collaborators
      - unknown
    - `date_force_timezone` string, nullable — Force a timezone for the field overriding user profile settings.
    - `select_options` SelectOption[], nullable, required
      - `id` integer
      - `value` string, required
      - `color` string, required
    - `available_collaborators` Collaborator[], nullable, required — A list of all the available collaborators.
      - `id` integer, required
      - `name` string, required
    - `date_format` union — EU (20/02/2020), US (02/20/2020) or ISO (2020-02-20) * `EU` - European (D/M/Y) * `US` - US (M/D/Y) * `ISO` - ISO (Y-M-D)
      - 'EU' | 'US' | 'ISO' — * `EU` - European (D/M/Y) * `US` - US (M/D/Y) * `ISO` - ISO (Y-M-D)
      - unknown
    - `date_time_format` union — 24 (14:30) or 12 (02:30 PM) * `24` - 24 hour * `12` - 12 hour
      - '24' | '12' — * `24` - 24 hour * `12` - 12 hour
      - unknown
    - `date_show_tzinfo` boolean, nullable — Indicates if the time zone should be shown.
    - `duration_format` union — The format of the duration. * `h:mm` - hours:minutes * `h:mm:ss` - hours:minutes:seconds * `h:mm:ss.s` - hours:minutes:seconds:deciseconds * `h:mm:ss.ss` - hours:minutes:seconds:centiseconds * `h:mm:ss.sss` - hours:minutes:seconds:milliseconds * `d h` - days:hours * `d h:mm` - days:hours:minutes * `d h:mm:ss` - days:hours:minutes:seconds * `d h mm` - days:hours:minutes:with_spaces * `d h mm ss` - days:hours:minutes:seconds:with_spaces
      - 'h:mm' | 'h:mm:ss' | 'h:mm:ss.s' | 'h:mm:ss.ss' | 'h:mm:ss.sss' | 'd h' | 'd h:mm' | 'd h:mm:ss' | 'd h mm' | 'd h mm ss' — * `h:mm` - hours:minutes * `h:mm:ss` - hours:minutes:seconds * `h:mm:ss.s` - hours:minutes:seconds:deciseconds * `h:mm:ss.ss` - hours:minutes:seconds:centiseconds * `h:mm:ss.sss` - hours:minutes:seconds:milliseconds * `d h` - days:hours * `d h:mm` - days:hours:minutes * `d h:mm:ss` - days:hours:minutes:seconds * `d h mm` - days:hours:minutes:with_spaces * `d h mm ss` - days:hours:minutes:seconds:with_spaces
      - unknown
    - `number_separator` union — The thousand and decimal separator to use for the field. * `` - No formatting * `SPACE_COMMA` - Space, comma * `SPACE_PERIOD` - Space, period * `COMMA_PERIOD` - Comma, period * `PERIOD_COMMA` - Period, comma
      - 'SPACE_COMMA' | 'SPACE_PERIOD' | 'COMMA_PERIOD' | 'PERIOD_COMMA' — * `` - No formatting * `SPACE_COMMA` - Space, comma * `SPACE_PERIOD` - Space, period * `COMMA_PERIOD` - Comma, period * `PERIOD_COMMA` - Period, comma
      - ''
    - `number_suffix` string
    - `number_negative` boolean, required
    - `number_decimal_places` union — The amount of digits allowed after the point. * `0` - 1 * `1` - 1.0 * `2` - 1.00 * `3` - 1.000 * `4` - 1.0000 * `5` - 1.00000 * `6` - 1.000000 * `7` - 1.0000000 * `8` - 1.00000000 * `9` - 1.000000000 * `10` - 1.0000000000
      - 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 — * `0` - 1 * `1` - 1.0 * `2` - 1.00 * `3` - 1.000 * `4` - 1.0000 * `5` - 1.00000 * `6` - 1.000000 * `7` - 1.0000000 * `8` - 1.00000000 * `9` - 1.000000000 * `10` - 1.0000000000
      - unknown
    - `number_prefix` string
    - `date_include_time` boolean, nullable — Indicates if the field also includes a time.
    - `error` string, required
    - `formula` string, required
    - `formula_type` 'invalid' | 'text' | 'char' | 'button' | 'link' | 'date_interval' | 'duration' | 'date' | 'boolean' | 'number' | 'array' | 'single_select' | 'multiple_select' | 'single_file' | 'url' | 'multiple_collaborators' — * `invalid` - invalid * `text` - text * `char` - char * `button` - button * `link` - link * `date_interval` - date_interval * `duration` - duration * `date` - date * `boolean` - boolean * `number` - number * `array` - array * `single_select` - single_select * `multiple_select` - multiple_select * `single_file` - single_file * `url` - url * `multiple_collaborators` - multiple_collaborators
  - CountFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `nullable` boolean, required
    - `array_formula_type` union
      - 'invalid' | 'text' | 'char' | 'button' | 'link' | 'date_interval' | 'duration' | 'date' | 'boolean' | 'number' | 'single_select' | 'multiple_select' | 'single_file' | 'url' | 'multiple_collaborators' — * `invalid` - invalid * `text` - text * `char` - char * `button` - button * `link` - link * `date_interval` - date_interval * `duration` - duration * `date` - date * `boolean` - boolean * `number` - number * `single_select` - single_select * `multiple_select` - multiple_select * `single_file` - single_file * `url` - url * `multiple_collaborators` - multiple_collaborators
      - unknown
    - `date_force_timezone` string, nullable — Force a timezone for the field overriding user profile settings.
    - `date_format` union — EU (20/02/2020), US (02/20/2020) or ISO (2020-02-20) * `EU` - European (D/M/Y) * `US` - US (M/D/Y) * `ISO` - ISO (Y-M-D)
      - 'EU' | 'US' | 'ISO' — * `EU` - European (D/M/Y) * `US` - US (M/D/Y) * `ISO` - ISO (Y-M-D)
      - unknown
    - `date_time_format` union — 24 (14:30) or 12 (02:30 PM) * `24` - 24 hour * `12` - 12 hour
      - '24' | '12' — * `24` - 24 hour * `12` - 12 hour
      - unknown
    - `date_show_tzinfo` boolean, nullable — Indicates if the time zone should be shown.
    - `duration_format` union — The format of the duration. * `h:mm` - hours:minutes * `h:mm:ss` - hours:minutes:seconds * `h:mm:ss.s` - hours:minutes:seconds:deciseconds * `h:mm:ss.ss` - hours:minutes:seconds:centiseconds * `h:mm:ss.sss` - hours:minutes:seconds:milliseconds * `d h` - days:hours * `d h:mm` - days:hours:minutes * `d h:mm:ss` - days:hours:minutes:seconds * `d h mm` - days:hours:minutes:with_spaces * `d h mm ss` - days:hours:minutes:seconds:with_spaces
      - 'h:mm' | 'h:mm:ss' | 'h:mm:ss.s' | 'h:mm:ss.ss' | 'h:mm:ss.sss' | 'd h' | 'd h:mm' | 'd h:mm:ss' | 'd h mm' | 'd h mm ss' — * `h:mm` - hours:minutes * `h:mm:ss` - hours:minutes:seconds * `h:mm:ss.s` - hours:minutes:seconds:deciseconds * `h:mm:ss.ss` - hours:minutes:seconds:centiseconds * `h:mm:ss.sss` - hours:minutes:seconds:milliseconds * `d h` - days:hours * `d h:mm` - days:hours:minutes * `d h:mm:ss` - days:hours:minutes:seconds * `d h mm` - days:hours:minutes:with_spaces * `d h mm ss` - days:hours:minutes:seconds:with_spaces
      - unknown
    - `number_separator` union — The thousand and decimal separator to use for the field. * `` - No formatting * `SPACE_COMMA` - Space, comma * `SPACE_PERIOD` - Space, period * `COMMA_PERIOD` - Comma, period * `PERIOD_COMMA` - Period, comma
      - 'SPACE_COMMA' | 'SPACE_PERIOD' | 'COMMA_PERIOD' | 'PERIOD_COMMA' — * `` - No formatting * `SPACE_COMMA` - Space, comma * `SPACE_PERIOD` - Space, period * `COMMA_PERIOD` - Comma, period * `PERIOD_COMMA` - Period, comma
      - ''
    - `number_suffix` string — The suffix to use for the field.
    - `number_decimal_places` union — The amount of digits allowed after the point. * `0` - 1 * `1` - 1.0 * `2` - 1.00 * `3` - 1.000 * `4` - 1.0000 * `5` - 1.00000 * `6` - 1.000000 * `7` - 1.0000000 * `8` - 1.00000000 * `9` - 1.000000000 * `10` - 1.0000000000
      - 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 — * `0` - 1 * `1` - 1.0 * `2` - 1.00 * `3` - 1.000 * `4` - 1.0000 * `5` - 1.00000 * `6` - 1.000000 * `7` - 1.0000000 * `8` - 1.00000000 * `9` - 1.000000000 * `10` - 1.0000000000
      - unknown
    - `number_prefix` string — The prefix to use for the field.
    - `date_include_time` boolean, nullable — Indicates if the field also includes a time.
    - `error` string, nullable
    - `through_field_id` integer, nullable — The id of the link row field to count values for.
    - `formula_type` 'invalid' | 'text' | 'char' | 'button' | 'link' | 'date_interval' | 'duration' | 'date' | 'boolean' | 'number' | 'array' | 'single_select' | 'multiple_select' | 'single_file' | 'url' | 'multiple_collaborators' — * `invalid` - invalid * `text` - text * `char` - char * `button` - button * `link` - link * `date_interval` - date_interval * `duration` - duration * `date` - date * `boolean` - boolean * `number` - number * `array` - array * `single_select` - single_select * `multiple_select` - multiple_select * `single_file` - single_file * `url` - url * `multiple_collaborators` - multiple_collaborators
  - RollupFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `nullable` boolean, required
    - `array_formula_type` union
      - 'invalid' | 'text' | 'char' | 'button' | 'link' | 'date_interval' | 'duration' | 'date' | 'boolean' | 'number' | 'single_select' | 'multiple_select' | 'single_file' | 'url' | 'multiple_collaborators' — * `invalid` - invalid * `text` - text * `char` - char * `button` - button * `link` - link * `date_interval` - date_interval * `duration` - duration * `date` - date * `boolean` - boolean * `number` - number * `single_select` - single_select * `multiple_select` - multiple_select * `single_file` - single_file * `url` - url * `multiple_collaborators` - multiple_collaborators
      - unknown
    - `date_force_timezone` string, nullable — Force a timezone for the field overriding user profile settings.
    - `select_options` SelectOption[], nullable, required
      - `id` integer
      - `value` string, required
      - `color` string, required
    - `available_collaborators` Collaborator[], nullable, required — A list of all the available collaborators.
      - `id` integer, required
      - `name` string, required
    - `date_format` union — EU (20/02/2020), US (02/20/2020) or ISO (2020-02-20) * `EU` - European (D/M/Y) * `US` - US (M/D/Y) * `ISO` - ISO (Y-M-D)
      - 'EU' | 'US' | 'ISO' — * `EU` - European (D/M/Y) * `US` - US (M/D/Y) * `ISO` - ISO (Y-M-D)
      - unknown
    - `date_time_format` union — 24 (14:30) or 12 (02:30 PM) * `24` - 24 hour * `12` - 12 hour
      - '24' | '12' — * `24` - 24 hour * `12` - 12 hour
      - unknown
    - `date_show_tzinfo` boolean, nullable — Indicates if the time zone should be shown.
    - `duration_format` union — The format of the duration. * `h:mm` - hours:minutes * `h:mm:ss` - hours:minutes:seconds * `h:mm:ss.s` - hours:minutes:seconds:deciseconds * `h:mm:ss.ss` - hours:minutes:seconds:centiseconds * `h:mm:ss.sss` - hours:minutes:seconds:milliseconds * `d h` - days:hours * `d h:mm` - days:hours:minutes * `d h:mm:ss` - days:hours:minutes:seconds * `d h mm` - days:hours:minutes:with_spaces * `d h mm ss` - days:hours:minutes:seconds:with_spaces
      - 'h:mm' | 'h:mm:ss' | 'h:mm:ss.s' | 'h:mm:ss.ss' | 'h:mm:ss.sss' | 'd h' | 'd h:mm' | 'd h:mm:ss' | 'd h mm' | 'd h mm ss' — * `h:mm` - hours:minutes * `h:mm:ss` - hours:minutes:seconds * `h:mm:ss.s` - hours:minutes:seconds:deciseconds * `h:mm:ss.ss` - hours:minutes:seconds:centiseconds * `h:mm:ss.sss` - hours:minutes:seconds:milliseconds * `d h` - days:hours * `d h:mm` - days:hours:minutes * `d h:mm:ss` - days:hours:minutes:seconds * `d h mm` - days:hours:minutes:with_spaces * `d h mm ss` - days:hours:minutes:seconds:with_spaces
      - unknown
    - `number_separator` union — The thousand and decimal separator to use for the field. * `` - No formatting * `SPACE_COMMA` - Space, comma * `SPACE_PERIOD` - Space, period * `COMMA_PERIOD` - Comma, period * `PERIOD_COMMA` - Period, comma
      - 'SPACE_COMMA' | 'SPACE_PERIOD' | 'COMMA_PERIOD' | 'PERIOD_COMMA' — * `` - No formatting * `SPACE_COMMA` - Space, comma * `SPACE_PERIOD` - Space, period * `COMMA_PERIOD` - Comma, period * `PERIOD_COMMA` - Period, comma
      - ''
    - `number_suffix` string
    - `number_negative` boolean, required
    - `number_decimal_places` union — The amount of digits allowed after the point. * `0` - 1 * `1` - 1.0 * `2` - 1.00 * `3` - 1.000 * `4` - 1.0000 * `5` - 1.00000 * `6` - 1.000000 * `7` - 1.0000000 * `8` - 1.00000000 * `9` - 1.000000000 * `10` - 1.0000000000
      - 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 — * `0` - 1 * `1` - 1.0 * `2` - 1.00 * `3` - 1.000 * `4` - 1.0000 * `5` - 1.00000 * `6` - 1.000000 * `7` - 1.0000000 * `8` - 1.00000000 * `9` - 1.000000000 * `10` - 1.0000000000
      - unknown
    - `number_prefix` string
    - `date_include_time` boolean, nullable — Indicates if the field also includes a time.
    - `error` string, nullable
    - `through_field_id` integer, nullable — The id of the link row field to rollup values for.
    - `target_field_id` integer, nullable — The id of the field in the table linked to by the through_field to rollup.
    - `rollup_function` string — The rollup formula function that must be applied.
    - `formula_type` 'invalid' | 'text' | 'char' | 'button' | 'link' | 'date_interval' | 'duration' | 'date' | 'boolean' | 'number' | 'array' | 'single_select' | 'multiple_select' | 'single_file' | 'url' | 'multiple_collaborators' — * `invalid` - invalid * `text` - text * `char` - char * `button` - button * `link` - link * `date_interval` - date_interval * `duration` - duration * `date` - date * `boolean` - boolean * `number` - number * `array` - array * `single_select` - single_select * `multiple_select` - multiple_select * `single_file` - single_file * `url` - url * `multiple_collaborators` - multiple_collaborators
  - LookupFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `nullable` boolean, required
    - `array_formula_type` union
      - 'invalid' | 'text' | 'char' | 'button' | 'link' | 'date_interval' | 'duration' | 'date' | 'boolean' | 'number' | 'single_select' | 'multiple_select' | 'single_file' | 'url' | 'multiple_collaborators' — * `invalid` - invalid * `text` - text * `char` - char * `button` - button * `link` - link * `date_interval` - date_interval * `duration` - duration * `date` - date * `boolean` - boolean * `number` - number * `single_select` - single_select * `multiple_select` - multiple_select * `single_file` - single_file * `url` - url * `multiple_collaborators` - multiple_collaborators
      - unknown
    - `date_force_timezone` string, nullable — Force a timezone for the field overriding user profile settings.
    - `select_options` SelectOption[], nullable, required
      - `id` integer
      - `value` string, required
      - `color` string, required
    - `available_collaborators` Collaborator[], nullable, required — A list of all the available collaborators.
      - `id` integer, required
      - `name` string, required
    - `date_format` union — EU (20/02/2020), US (02/20/2020) or ISO (2020-02-20) * `EU` - European (D/M/Y) * `US` - US (M/D/Y) * `ISO` - ISO (Y-M-D)
      - 'EU' | 'US' | 'ISO' — * `EU` - European (D/M/Y) * `US` - US (M/D/Y) * `ISO` - ISO (Y-M-D)
      - unknown
    - `date_time_format` union — 24 (14:30) or 12 (02:30 PM) * `24` - 24 hour * `12` - 12 hour
      - '24' | '12' — * `24` - 24 hour * `12` - 12 hour
      - unknown
    - `date_show_tzinfo` boolean, nullable — Indicates if the time zone should be shown.
    - `duration_format` union — The format of the duration. * `h:mm` - hours:minutes * `h:mm:ss` - hours:minutes:seconds * `h:mm:ss.s` - hours:minutes:seconds:deciseconds * `h:mm:ss.ss` - hours:minutes:seconds:centiseconds * `h:mm:ss.sss` - hours:minutes:seconds:milliseconds * `d h` - days:hours * `d h:mm` - days:hours:minutes * `d h:mm:ss` - days:hours:minutes:seconds * `d h mm` - days:hours:minutes:with_spaces * `d h mm ss` - days:hours:minutes:seconds:with_spaces
      - 'h:mm' | 'h:mm:ss' | 'h:mm:ss.s' | 'h:mm:ss.ss' | 'h:mm:ss.sss' | 'd h' | 'd h:mm' | 'd h:mm:ss' | 'd h mm' | 'd h mm ss' — * `h:mm` - hours:minutes * `h:mm:ss` - hours:minutes:seconds * `h:mm:ss.s` - hours:minutes:seconds:deciseconds * `h:mm:ss.ss` - hours:minutes:seconds:centiseconds * `h:mm:ss.sss` - hours:minutes:seconds:milliseconds * `d h` - days:hours * `d h:mm` - days:hours:minutes * `d h:mm:ss` - days:hours:minutes:seconds * `d h mm` - days:hours:minutes:with_spaces * `d h mm ss` - days:hours:minutes:seconds:with_spaces
      - unknown
    - `number_separator` union — The thousand and decimal separator to use for the field. * `` - No formatting * `SPACE_COMMA` - Space, comma * `SPACE_PERIOD` - Space, period * `COMMA_PERIOD` - Comma, period * `PERIOD_COMMA` - Period, comma
      - 'SPACE_COMMA' | 'SPACE_PERIOD' | 'COMMA_PERIOD' | 'PERIOD_COMMA' — * `` - No formatting * `SPACE_COMMA` - Space, comma * `SPACE_PERIOD` - Space, period * `COMMA_PERIOD` - Comma, period * `PERIOD_COMMA` - Period, comma
      - ''
    - `number_suffix` string
    - `number_negative` boolean, required
    - `number_decimal_places` union — The amount of digits allowed after the point. * `0` - 1 * `1` - 1.0 * `2` - 1.00 * `3` - 1.000 * `4` - 1.0000 * `5` - 1.00000 * `6` - 1.000000 * `7` - 1.0000000 * `8` - 1.00000000 * `9` - 1.000000000 * `10` - 1.0000000000
      - 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 — * `0` - 1 * `1` - 1.0 * `2` - 1.00 * `3` - 1.000 * `4` - 1.0000 * `5` - 1.00000 * `6` - 1.000000 * `7` - 1.0000000 * `8` - 1.00000000 * `9` - 1.000000000 * `10` - 1.0000000000
      - unknown
    - `number_prefix` string
    - `date_include_time` boolean, nullable — Indicates if the field also includes a time.
    - `error` string, required
    - `through_field_id` integer, nullable — The id of the link row field to lookup values for. Will override the `through_field_name` parameter if both are provided, however only one is required.
    - `through_field_name` string, nullable — The name of the link row field to lookup values for.
    - `target_field_id` integer, nullable — The id of the field in the table linked to by the through_field to lookup. Will override the `target_field_id` parameter if both are provided, however only one is required.
    - `target_field_name` string, nullable — The name of the field in the table linked to by the through_field to lookup.
    - `formula_type` 'invalid' | 'text' | 'char' | 'button' | 'link' | 'date_interval' | 'duration' | 'date' | 'boolean' | 'number' | 'array' | 'single_select' | 'multiple_select' | 'single_file' | 'url' | 'multiple_collaborators' — * `invalid` - invalid * `text` - text * `char` - char * `button` - button * `link` - link * `date_interval` - date_interval * `duration` - duration * `date` - date * `boolean` - boolean * `number` - number * `array` - array * `single_select` - single_select * `multiple_select` - multiple_select * `single_file` - single_file * `url` - url * `multiple_collaborators` - multiple_collaborators
  - MultipleCollaboratorsFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `available_collaborators` Collaborator[], required — A list of all the available collaborators.
      - `id` integer, required
      - `name` string, required
    - `notify_user_when_added` boolean
  - UUIDFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
  - AutonumberFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
  - PasswordFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `allow_endpoint_authentication` boolean — If true, then it's possible to use the `password_field_authentication` API endpoint to check if the password is correct. This can be used to use Baserow as authentication backend.
  - FormViewEditRowFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `form_view_id` integer, nullable — The id of the form view used to edit rows via this field.
  - ButtonFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `label` string — The text shown on the button. Must be provided when the field is created, and can't be set to an empty value afterwards.
    - `url_formula` object — Formula resolved per row in the client to build the URL the button opens. Can reference the row's fields via get('fields.field_<id>').
    - `error` string, nullable, required — The error message if the field's URL formula is broken, else null.
  - AIFieldField
    - `id` integer, required
    - `table_id` integer, required
    - `name` string, required
    - `order` integer, required — Lowest first.
    - `type` string, required — The type of the related field.
    - `primary` boolean — Indicates if the field is a primary field. If `true` the field cannot be deleted and the value should represent the whole row.
    - `read_only` boolean, required — Indicates whether the field is a read only field. If true, it's not possible to update the cell value.
    - `immutable_type` boolean, required — Indicates whether the field type is immutable. If true, then it won't be possible to change the field type via the API.
    - `immutable_properties` boolean, required — Indicates whether the field properties are immutable. If true, then it won't be possible to change the properties and the type via the API.
    - `description` string, nullable — Field description
    - `database_id` integer, required — The ID of the database this field belongs to.
    - `workspace_id` integer, required — The ID of the workspace this field belongs to.
    - `db_index` boolean — If true, then an index will be added to the Baserow field to increase lookup and filter speed. Note that this comes at a performance cost when creating the row and updating the cell.
    - `field_constraints` string, required — The constraints applied to this field.
    - `select_options` SelectOption[]
      - `id` integer
      - `value` string, required
      - `color` string, required
    - `ai_generative_ai_type` string, nullable
    - `ai_generative_ai_model` string, nullable
    - `ai_output_type` 'text' | 'choice' — * `text` - text * `choice` - choice
    - `ai_temperature` number, double, nullable — Between 0 and 2, adjusts response randomness—lower values yield focused answers, while higher values increase creativity.
    - `ai_prompt` object — The prompt that must run for each row. Must be an formula.
    - `ai_file_field_id` integer, nullable — File field that will be used as a knowledge base for the AI model.
    - `ai_auto_update` boolean, nullable — If set, AI field will be recalculated if a value of a referenced field has been changed.
    - `error` string, nullable, required — The error message if the field's prompt or model configuration is invalid, else null.

## Other responses

- `400`
- `404`

---

[API](https://skmtc.net/baserow/apis/baserow-api-spec.md) · [All operations](https://skmtc.net/baserow/apis/baserow-api-spec/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/baserow/baserow-api-spec/versions/0c490e5b0c7f/schema)