Column Types

FlowStack Tables supports typed columns to ensure data integrity and enable type-specific filtering.

Available Types

Type	Description	Example Values
Text	Free-form text string	"John Doe", "Order shipped"
Number	Integer or decimal number	42, 99.99, -5
Boolean	True/false value	true, false
Date	Date with optional time	2026-04-21, 2026-04-21T10:30:00Z
Email	Email address (validated format)	jane@example.com
URL	Web URL (validated format)	https://example.com/page
Select	Single choice from predefined options	"Active", "Pending", "Closed"
Multi-Select	Multiple choices from predefined options	["Marketing", "Sales"]
JSON	Arbitrary JSON data	{"key": "value"}

Type Details

Text

• Maximum length: 10,000 characters
• Supports full-text search
• Use for names, descriptions, notes, addresses

Number

• Supports integers and floating-point numbers
• Range: ±9,007,199,254,740,991 (JavaScript safe integer range)
• Decimal precision: up to 10 decimal places
• Use for prices, quantities, scores, measurements

Boolean

• Renders as a checkbox in the table UI
• Stores as true or false
• Use for flags: is_active, is_verified, has_responded

Date

• Stored in ISO 8601 format
• Renders with a date picker in the UI
• Supports date-only (2026-04-21) or datetime (2026-04-21T10:30:00Z)
• Use for created_at, due_date, last_contacted

Select

• Define options when creating the column (e.g., "Active", "Pending", "Closed")
• Users choose from a dropdown in the UI
• Add new options in column settings at any time
• Use for status fields, categories, priorities

Multi-Select

• Same as Select, but allows multiple selections
• Stored as an array of strings
• Use for tags, labels, categories (when items can belong to multiple)

JSON

• Stores arbitrary JSON objects or arrays
• No schema validation (flexible structure)
• Renders as a code editor in the UI
• Use for metadata, configuration, API response storage

Choosing the Right Type

I need to store...	Use
Names, addresses, notes	Text
Prices, quantities	Number
Yes/no flags	Boolean
Timestamps, due dates	Date
Contact emails	Email
Website links	URL
Status with fixed options	Select
Tags or labels	Multi-Select
Complex nested data	JSON