Kition
Download
Data tables

Field types deep dive: select / multi-select / lookup / formula

Don’t make everything `text`. The right field types make queries, views, and the agent much happier.

Kition Team·Mar 12, 2026·7 min read

Core types

  • text / rich-text — default
  • number — sort, aggregate
  • select / multi-select — finite value sets
  • date — required for calendar view
  • attachment — files
  • url — auto OpenGraph preview
  • lookup — cross-table reference
  • formula — per-row computation
  • ai-field — LLM-computed

Picking guidance

  • "A small set of values" → select / multi-select, not text
  • "Time-related" → date in ISO `2026-03-12`, not "March 12"
  • "Cross-table relations" → lookup
  • "Computed values" → formula first, AI field as fallback
← Back to blogMore in Data tables →

Related reading

Data tables

Kition tables vs Notion databases: what differs

Same Grid / Kanban / Calendar views — but Kition tables are local `.kitable` files, and the agent can read/write them directly.

Data tables

AI fields in practice: auto-fill columns from your data

An AI Field is a column whose value runs a prompt template — fills automatically as you edit other columns.

Ready when you are.

Kition is a local-first AI workspace. Markdown documents, structured tables, and an AI agent — running on your own machine, against the model provider you choose.

Download KitionPricing