Skip to main content

Number

Number fields store integer values without decimals.

View all settings
SettingDescription
Field NameText input, required. Unique identifier for the field.
Input TypeDropdown, required. Choose Bigint, Integer, or Small Int.
Default ValueNumber input. Pre-filled value for new records.
Display LabelText input. Human-readable label shown in forms.
Sort OrderNumber input, defaults to 0. Position in field lists.
IconIcon picker. Visual identifier.
StatusToggle, defaults to true. Enable or disable the field.
RequiredCheckbox. Make the field mandatory.
DescriptionText area. Documents the field's purpose.
Form VisibilityDropdown. Show in Add, Edit, or Both forms.
DB Field NameText input. Custom database column name.
Faker TypeDropdown. Generate test data.
Primary KeyCheckbox. Mark as unique record identifier.
UniqueCheckbox. Prevent duplicate values.
Use as IndexCheckbox. Create database index for performance.
Populate from Logged-In UserCheckbox. Auto-fill from user session.
Min ValueNumber input. Minimum allowed value.
Max ValueNumber 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

When to Use​

Choose Number over Decimal when:

  • You only need whole numbers (no fractions)
  • Working with counts, quantities, or IDs
  • Performance and storage efficiency matter

Settings​

See Common Settings for shared options. Number supports Primary Key and Unique.

Validation (Advanced Settings)​

SettingDescription
Min ValueMinimum allowed value.
Max ValueMaximum allowed value.

Use Cases​

  • Quantities and counts (inventory, stock levels)
  • Age, rating scores, or ranking positions
  • Foreign keys and numeric IDs
  • Order numbers and sequence values