Forms¶
The Form Builder lets you create data-entry forms that are linked to sheets, providing a user-friendly interface for adding and editing records.
Creating a Form¶
Open the Form Builder from the Database menu or the Navigation Panel under Forms. Click New Form to create a form linked to the active sheet. The form is given a default name which you can rename.
Field Types¶
Each form field maps to a column in the linked sheet. Supported field types:
| Type | Description |
|---|---|
| Text | Single-line text input. |
| Number | Numeric input. |
| Date | Date picker. |
| Time | Time picker. |
| Textarea | Multi-line text input. |
| Dropdown | Select from a predefined list of options. |
| Checkbox | Boolean yes/no toggle. |
| Email address input with basic validation. |
Design Mode¶
In design mode you can:
- Add fields from the toolbar and configure their label, type, and linked column.
- Reorder fields by dragging them up or down.
- Set form title and description displayed at the top of the form.
- Delete fields that are no longer needed.
Data Entry Mode¶
Switch out of design mode to use the form for data entry. Fill in the fields and submit to append a new row to the linked sheet. The form automatically maps each field value to the correct column.
Managing Forms¶
Forms appear as tabs alongside sheet tabs. Use the Navigation Panel or right-click context menus to rename, duplicate, or delete forms. Form definitions are saved as part of the workbook.