Number
Number fields store both integer and decimal values.
Go to Studio → Collections → [Collection Name] → Fields tab → Add Field, then select Number. To edit an existing field, click the edit action next to it.
View all settings
Basic Settings
| Setting | Description |
|---|---|
| Field Name | Text input, required. Unique identifier for the field. |
| Input Type | Dropdown, required. Choose Bigint, Integer, Small Int, Decimal, Double, Float, or Real. |
| Default Value | Number input. Pre-filled value for new records. |
| Display Label | Text input. Human-readable label shown in forms. |
| Icon | Icon picker. Visual identifier. |
| Status | Toggle, defaults to true. Enable or disable the field. |
| Required | Checkbox. Make the field mandatory. |
Advanced Settings
| Setting | Description |
|---|---|
| Description | Text area. Documents the field's purpose. |
| Form Visibility | Dropdown. Show in Add, Edit, or Both forms. |
| DB Field Name | Text input. Custom database column name. |
| Primary Key | Checkbox. Mark as unique record identifier. |
| Unique | Checkbox. Prevent duplicate values. |
| Faker Type | Dropdown. Disabled and Deprecated. Configure faker through collection options for each field. |
| Min Value | Number input. Minimum allowed value. |
| Max Value | Number input. Maximum allowed value. |
Input Types
- Bigint — 8-byte integer for very large values (up to ±9 quintillion). Use for IDs or large counters
- Integer — 4-byte standard integer (up to ±2 billion). Best for most use cases
- Small Int — 2-byte integer (up to ±32,767). Saves storage for small ranges
- Decimal — Exact numeric with user-defined precision. Best for currency and financial data
- Double — 8-byte floating-point with ~15 digits precision. Good for scientific calculations
- Float — 4-byte floating-point with ~7 digits precision. Saves storage but less precise
- Real — Alias for Float in PostgreSQL
Settings
See Common Settings for shared options.
Validation (Advanced Settings)
| Setting | Description |
|---|---|
| Min Value | Minimum allowed value. |
| Max Value | Maximum allowed value. |
Use Cases
- Quantities and counts (inventory, stock levels)
- Age, rating scores, or ranking positions
- Foreign keys and numeric IDs
- Prices and currency amounts (use Decimal)
- Measurements (weight, dimensions, distance)
- Percentages and ratios
Related
- Common Settings — Shared settings reference
- Auto Generated — For auto-incrementing IDs