Fields
🔢
Fields
15+ field types to structure your data exactly how you need it.
Field types
SAJEL supports a wide range of field types:
| Type | Description | Example |
|---|---|---|
| Text | Short text, single line | "John Smith" |
| Long Text | Multi-line with formatting | Meeting notes, descriptions |
| Number | Integers or decimals | 42, 3.14 |
| Select | Single choice from options | Status: Active |
| Multi-Select | Multiple choices | Tags: Urgent, Frontend |
| Date | Date with optional time | 2025-03-15 |
| Checkbox | True/false toggle | Completed: Yes |
| User Reference | Link to workspace members | Assigned to: Sara |
| Link to Board | Relationships between boards | Related tickets |
| Lookup | Pull data from linked records | Customer name from linked order |
| Rollup | Aggregate linked data | Total order amount (SUM) |
| Formula | Computed values | Price * Quantity |
| Attachment | File uploads | invoice.pdf |
| URL | Web links | https://example.com |
| Email addresses | team@company.com | |
| Phone | Phone numbers | +966 50 123 4567 |
| Currency | Monetary values | SAR 1,500.00 |
Link fields
Link fields create relationships between boards. When you link Board A to Board B:
•A link field is created in Board A
•A reciprocal link field is automatically created in Board B
•You can then add Lookup and Rollup fields to pull or aggregate data across the link
Link fields work between boards in the same base. Cross-base linking is coming soon.
Lookup and Rollup fields
Lookup fields pull specific field values from linked records. If Board A links to Board B, a lookup on Board A can display any field from the linked Board B records.
Rollup fields aggregate values from linked records:
| Function | What it does | Example |
|---|---|---|
| SUM | Total of numeric values | Total order value |
| COUNT | Number of linked records | Number of tasks |
| AVG | Average of numeric values | Average rating |
| MIN / MAX | Smallest or largest value | Earliest due date |
| CONCAT | Join text values | All tag names |
Field settings
Each field can be configured with:
•Name — The column header displayed in the grid
•Description — Help text shown on hover
•Required — Whether the field must have a value
•Default value — Pre-filled value for new records
•Field-specific options — Like number format, select options, linked board, etc.
To edit a field, click the dropdown arrow next to the field name in the grid header.