Table Settings
Each table has its own settings area, opened via the Settings button on the table dashboard or the cog icon next to the table in the left navigation. Settings are organised into four panels: Structure, User Interface, Automations, and Advanced.
Opening table settings requires an application where your role has admin or limited admin access, or the Access Table Settings permission on the table. Table-level operations are also available through the REST API; see the Tables endpoint reference.
Panels
| Panel | Sections |
|---|---|
| Structure | Fields |
| User Interface | Forms, Reports, Dashboards |
| Automations | Emails, Webhooks |
| Advanced | Properties, Maintenance |
Each list section (Fields, Forms, Reports, Dashboards, Emails, Webhooks) offers view, edit, and duplicate actions, plus an Add button for creating new items. Emails and webhooks fire on table activity and are reviewed under Application Settings → Advanced → Job Logs.
Properties
The Properties section (Advanced panel) configures the table itself. The same form appears when creating a table, with these sections available when editing:
Basics
| Setting | What it does |
|---|---|
| Table Icon | The table's icon in menus and lists |
| Table Name | The table's unique name within the application; renaming the table is done here |
| Singular Noun | The singular display label used on buttons, menus, and record titles |
| Plural Noun | The plural display label |
| Table Description | An optional description |
UI Settings
| Setting | What it does |
|---|---|
| Default Dashboard | The dashboard shown when the table is opened and no role default applies |
| Default Form | The form used when a record is opened and no role default applies |
Form Settings
| Setting | What it does |
|---|---|
| Record Label | The field shown as a record's display name |
| Record Picker | The fields shown when picking a record in a relationship |
Report Settings
| Setting | What it does |
|---|---|
| Default Search Type | Like or Lexeme matching for searches on the table |
| Default Columns | The columns shown in search results by default |
| Global Query | An optional query that filters every view of the table |
Advanced Settings
| Setting | What it does |
|---|---|
| Data Rules | An SQL rule evaluated per record at the database level; when the rule doesn't return true the operation is rejected. Use it for record-level constraints that must hold no matter how a record is created or edited |
Maintenance
The Maintenance section (Advanced panel) keeps a table healthy and manages its data:
| Operation | What it does |
|---|---|
| Analyze Vacuum | Database maintenance; the application may be slow while it runs |
| Rebuild Indexes | Rebuilds the table's indexes; same performance caveat |
| Generate Fake Data | Fills the table with 1,000 rows of sample data, connecting relationships to random parent rows; useful for testing |
| Delete Data | Empties the table without deleting the table itself, with an option to restart auto-incrementing fields |
| Dehydrate Data / Hydrate Data | Moves data in and out of the table's storage |
| Delete Table | Deletes the table; requires typing delete table to confirm |
Deleting a table removes its fields, records, reports, forms, dashboards, emails, webhooks, and permissions, and empties lookup fields elsewhere that reference it. Deletion cannot be undone.