Date & Time Columns
Date & Time
Full date with optional time component. Displays a calendar picker.
| Setting | Description |
|---|---|
| Include time | Show time picker alongside date |
| Date format | Display format (YYYY-MM-DD, MM/DD/YYYY, etc.) |
| Time format | 12-hour or 24-hour |
Use for: Created dates, due dates, event dates, appointment times.
Time
Time only, no date. Displays an hour:minute picker.
| Setting | Description |
|---|---|
| Format | 12-hour (AM/PM) or 24-hour |
Use for: Daily schedules, operating hours, shift times.
System date columns (read-only)
| Column | Description |
|---|---|
| Created Time | Automatically set when the record is created |
| Last Modified Time | Automatically updated on every edit |
These are read-only. They update automatically and cannot be manually edited.
Tip
Use Created Time and Last Modified Time system columns for audit trails. They're free, automatic, and can't be accidentally modified.
Adding columns
- Click the + button at the end of the column header row
- Select the column type from the dropdown
- Name the column
- Configure type-specific settings
- The column appears in the grid
Column operations
Right-click any column header for operations:
- Sort ascending/descending
- Hide column (per-view)
- Freeze column (pin to left)
- Resize column width
- Change type (with data conversion)
- Delete column
- Insert column left/right