Field Types

WISEROWS supports 18 field types for modeling any data shape. Each field type comes with its own input UI, validation rules, and rendering behavior across all four views.

This page is the complete reference. For an overview of how fields fit into entity types, see Entity Types.

Quick Reference

Basic Types

Text

Single-line text input. The most common field type -- use it for titles, names, slugs, and any short string value.

Configuration options:

{
  "name": "Title",
  "slug": "title",
  "type": "text",
  "required": true,
  "config": { "minLength": 1, "maxLength": 200 }
}

Long Text

Multi-line text area for longer content. Renders as a resizable textarea in forms and truncates in table cells.

Use this for descriptions, notes, summaries, and any plain-text content that may span multiple lines. For formatted content with headings, lists, and links, use Rich Text instead.

{
  "name": "Description",
  "slug": "description",
  "type": "longText",
  "required": false
}

Rich Text

Markdown-enabled text editor with a formatting toolbar. Supports:

• Bold, italic, and strikethrough
• Headings (H1 -- H6)
• Ordered and unordered lists
• Links and images
• Code blocks with syntax highlighting
• Tables
• Blockquotes

{
  "name": "Body Content",
  "slug": "body",
  "type": "richText",
  "required": true
}

Number

Numeric input with optional bounds and precision. Renders as a number input with increment/decrement buttons.

Configuration options:

{
  "name": "Price",
  "slug": "price",
  "type": "number",
  "required": true,
  "config": { "min": 0, "max": 999999, "step": 0.01 }
}

Boolean

True/false toggle. Renders as a switch in forms and a checkmark/cross icon in table view.

Great for flags like "is featured", "is published", "requires review", or any binary state.

{
  "name": "Featured",
  "slug": "is_featured",
  "type": "boolean",
  "required": false,
  "config": { "defaultValue": false }
}

Date Types

Date

Date picker without a time component. Stored as an ISO 8601 date string (e.g., 2026-03-21).

Use for publish dates, deadlines, birthdays, and any date where the specific time doesn't matter.

{
  "name": "Publish Date",
  "slug": "publish_date",
  "type": "date",
  "required": false
}

DateTime

Full date and time picker. Stored as a Unix timestamp (milliseconds since epoch).

Use for event start/end times, precise logging, and any data where both date and time matter.

{
  "name": "Event Start",
  "slug": "event_start",
  "type": "datetime",
  "required": true
}

Choice Types

Select

Single choice from a predefined list of options. Renders as a dropdown in forms and a colored badge in table view.

Configuration options:

{
  "name": "Status",
  "slug": "status",
  "type": "select",
  "required": true,
  "config": {
    "options": ["draft", "review", "published", "archived"]
  }
}

Multi-Select

Multiple choices from a predefined list. Renders as a tag input in forms and a row of chips in table view.

Use for tags, categories, labels, or any field where an entity can belong to multiple groups.

{
  "name": "Tags",
  "slug": "tags",
  "type": "multiSelect",
  "required": false,
  "config": {
    "options": ["tutorial", "news", "case-study", "product-update", "engineering"]
  }
}

Media Types

File

File upload field. Supports any file type. Files are stored securely in Convex file storage with automatic URL generation.

Use for PDFs, CSVs, spreadsheets, documents, and any non-image file attachment.

{
  "name": "Attachment",
  "slug": "attachment",
  "type": "file",
  "required": false
}

Image

Image upload with inline preview. Supports JPEG, PNG, WebP, and SVG formats.

Renders as a thumbnail in table view and a full preview in the entity detail page. Powers the Gallery view card thumbnails.

{
  "name": "Featured Image",
  "slug": "featured_image",
  "type": "image",
  "required": false
}

Link Types

URL

Validated URL input. Must start with http:// or https://. Renders as a clickable link in table view.

{
  "name": "Website",
  "slug": "website",
  "type": "url",
  "required": false
}

Email

Validated email address input. Renders as a clickable mailto: link in table view.

{
  "name": "Contact Email",
  "slug": "contact_email",
  "type": "email",
  "required": true
}

Advanced Types

JSON

Raw JSON editor with syntax highlighting and validation. Useful for storing structured metadata, configuration objects, or any data that doesn't fit neatly into other field types.

{
  "name": "Metadata",
  "slug": "metadata",
  "type": "json",
  "required": false
}

Example stored value:

{
  "og_image": "https://example.com/og.png",
  "schema_type": "Article",
  "custom_attributes": { "reading_time": 5, "difficulty": "beginner" }
}

Reference

Link to a single entity in another (or the same) entity type. Creates a foreign-key-like relationship.

Use for "belongs to" relationships: a Blog Post belongs to an Author, a Product belongs to a Category.

{
  "name": "Author",
  "slug": "author",
  "type": "reference",
  "required": false,
  "config": {
    "entityTypeSlug": "team-member"
  }
}

In the UI, reference fields render as a searchable dropdown showing the referenced entity type's title field.

Relation

Many-to-many relationship between entity types. Unlike reference (one-to-one), relation allows linking to multiple entities.

Use for tags, categories, or any case where entities on both sides can have multiple links: a Blog Post can have many Tags, and a Tag can appear on many Blog Posts.

{
  "name": "Related Products",
  "slug": "related_products",
  "type": "relation",
  "required": false,
  "config": {
    "entityTypeSlug": "product"
  }
}

AI Generated

Auto-generated field powered by AI. Configure a prompt template that references other fields using {field_slug} placeholders. When triggered, the AI uses the entity's other field values as context to generate this field's value.

{
  "name": "Meta Description",
  "slug": "meta_description",
  "type": "aiGenerated",
  "required": false,
  "config": {
    "prompt": "Write a compelling meta description for a blog post titled \"{title}\" about {topic}. Keep it under 160 characters. Focus on the value the reader gets."
  }
}

The generation can be triggered manually per entity or in bulk via the content generation system. The AI model used is configured at the project level.

Formula

Computed field based on other fields. Uses JavaScript expressions that reference field values via the fields object.

Formula fields are read-only -- their values are recalculated automatically when dependency fields change.

{
  "name": "Total",
  "slug": "total",
  "type": "formula",
  "required": false,
  "config": {
    "expression": "fields.price * fields.quantity"
  }
}

More expression examples:

Field Definition Schema

For developers working with the API, here is the complete field definition shape:

Frequently Asked Questions

Related