Fields Overview
Fields define the structure and data types for your collections. Each field represents a column in your database table with specific validation rules and UI behavior.
Fields Tab Overview
The Fields tab displays all fields in your collection with:
| Column | Description |
|---|---|
| Name | Field identifier used in code and queries |
| Type | How the field is generated (Single line, Auto generated, etc.) |
| Input Type | The UI input type (Text, Uuid, Date, etc.) |
| Attributes | Field properties (required, unique, searchable) |
| Status | Active or inactive |
| Action | Edit or delete the field |
Field Attributes
Fields can have various attributes indicated by icons in the Attributes column:
| Icon | Meaning |
|---|---|
| Database field — stored in the database | |
| Form field — editable in forms | |
| Primary key — unique record identifier | |
| Required — must have a value when submitting forms | |
| Unique — no duplicate values allowed | |
| Index — used as query optimization index | |
| Query filter configured — field has filter conditions set |
Adding a Field
- Navigate to your collection's Fields tab
- Click Add Field
- Select the field type from the picker
- Configure Basic Settings and Advanced Settings
- Click Save & Close
All fields share settings like Field Name, Status, and Required. See Common Settings for the full reference.
Field Types
Single Line
Names, emails, URLs, short text
Learn moreMulti Line
Descriptions, rich content, notes
Learn moreBoolean
Flags, toggles, yes/no
Learn moreDate
Dates, times, timestamps
Learn moreNumber
Integers, counts, IDs
Learn moreDecimal
Prices, measurements, percentages
Learn moreSelect
User-facing dropdowns, dynamic options
Learn moreEnum
Backend constants, type-safe values
Learn moreAuto Generated
UUIDs, serial IDs, timestamps
Learn moreSystem Generated
Auth data, IP, headers
Learn moreJSON
Flexible structured data
Learn moreRaw SQL
Custom PostgreSQL queries
Learn moreLookup
Read-only related data
Learn moreCompute
Calculated from other fields
Learn moreRelational
Foreign key relationships
Learn moreAssociation
Aggregated relation data
Learn more