Skip to main content
A collection is the equivalent of a table in a traditional database. Each collection has fields (columns) with specific data types and stores records (rows) that you can create, search, edit, and delete.

​
Creating a collection

Create Collection dialog with name, Base type, id/created/updated fields, and option to create indexes

Form for creating a new collection with default fields

1

Click + New collection

In the left sidebar, click the + New collection button located at the bottom of the collections panel.
2

Configure the basic details

Fill in the following fields:
  • Name — Collection name (required, e.g. “customers”, “products”)
  • Type — Collection type: Base (default) or View (read-only).
3

Add fields

Every new collection includes three automatic fields:
  • id — Unique record identifier (auto-generated)
  • created — Record creation date (Autodate)
  • updated — Date of last update (Autodate)
Click + New field to add your own fields.
4

Create the collection

Click Create to confirm.

​
Field types

Each field has a type that determines what data it can store and what validations apply:

​
Configuring fields

Click the gear icon (⚙) on any field to view its configuration options. Options vary depending on the field type. For Text type fields:
  • Min length / Max length — Minimum and maximum text length (5,000 characters maximum by default)
  • Validation pattern — Regular expression to validate the format (e.g. ^[a-z0-9]+$)
  • Nonempty — Marks the field as required
  • Hidden — Hides the field in the user interface.
  • Presentable — Marks the field as the representative field of the record
You can change the type of an existing field from the type dropdown in the collection settings. Keep in mind that changing the type may affect existing data.

​
Options by field type

Each field type offers its own configuration options:
Integers only (rejects decimals) and minimum/maximum values.
List of allowed options (at least one). You can enable multiple selection, which requires a minimum of 2 options.
Maximum size per file, single or multiple file, and allowed types via presets (Images, Audio, Video, Archives, Documents).
Related collection and single or multiple selection. You can also define what happens when a related record is deleted.
Configure the maximum length and security options to protect stored values.
Allowed or excluded domains to validate the value.
Date: minimum and maximum date. Autodate: define when it’s assigned automatically — on Create, on Update, or both.
Maximum content size.

​
Reordering fields

Click Reorder fields inside the collection settings to change the order in which fields appear in the table and in forms.

​
Indexes and unique constraints

At the bottom of the collection settings you will find the Unique constraints and indexes section. Indexes improve query performance on fields that are frequently filtered or searched. Click Create index to add a new index to your collection.

​
Collection settings

Collection settings panel showing name, type, field list with their types and configuration options

Collection settings panel with field list and types

Click the gear icon (⚙) next to the collection name at the top to access the full settings. From here you can:
  • Rename the collection
  • Add, edit, or delete fields
  • Reorder fields
  • Create indexes
The ⋯ menu in the upper-right corner of the settings offers additional actions:
  • Duplicate — Creates a copy of the collection.
  • Empty — Deletes all records while keeping the collection structure. Not available on views.
  • Delete — Deletes the collection entirely.
Empty and Delete are irreversible. Empty deletes all records; Delete also deletes the collection and its structure.