Skip to main content

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.

Go to Studio → Collections → [Collection Name] → Fields tab.

Fields Tab Overview

The Fields tab displays all fields in your collection with:

Column	Description
	Drag handle to reorder fields in the list
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)
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
	Edit in Form
	Primary Key
	Required
	Unique
	Relational Field
	Use As Index
	Filter Applied

Adding a Field

Go 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

note

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

Multi Line

Descriptions, rich content, notes

Boolean

Flags, toggles, yes/no

Date

Dates, times, timestamps

Number

Integers, decimals, counts, IDs

Choice

Single or multiple selections, enums

Auto Generated

UUIDs, serial IDs, timestamps

System Generated

Auth data, IP, headers

JSON

Flexible structured data

Raw SQL

Custom PostgreSQL queries

Lookup

Read-only related data

Compute

Calculated from other fields

Relational

Foreign key relationships

Association

Aggregated relation data

Fields Tab Overview
Field Attributes
Adding a Field
Field Types