Zite Database Field Types

string // e.g., "John Doe", "Product Name"

"single_line_text"

string // Multi-line text, e.g., "This is a long description\nwith multiple lines"

"long_text"

string // Valid email address, e.g., "user@example.com"

"email"

string // Valid URL, e.g., "https://example.com"

"url"

string // Phone number with any formatting, e.g., "+1 (555) 123-4567"

"phone_number"

number | null // e.g., 42.5, 1000, null

"number"

{
  "name": "Quantity",
  "template": {
    "decimalPlaces": 2,        // 0-10, default: 1
    "numberFormat": "local"     // "local" | "comma_period" | "period_comma" | "space_comma" | "space_period", default: "local"
  }
}

number | null // Stored as raw number, e.g., 99.99, 1000.00, null

"currency"

{
  "name": "Price",
  "template": {
    "currencySymbol": "$",      // default: "$"
    "decimalPlaces": 2,         // 0-10, default: 2
    "numberFormat": "local"     // "local" | "comma_period" | "period_comma" | "space_comma" | "space_period", default: "local"
  }
}

number | null // Stored as decimal (0.5 = 50%), e.g., 0.85, 1.0, null

"percent"

{
  "name": "Completion Rate",
  "template": {
    "decimalPlaces": 1,         // 0+, default: 0
    "numberFormat": "local",    // default: "local"
    "showProgressBar": true,    // default: false
    "allowNegative": false      // default: false
  }
}

number | null // Integer from 0 to maxRating, e.g., 4, 5, null

"rating"

{
  "name": "Customer Rating",
  "template": {
    "maxRating": 5              // 1-10, default: 5
  }
}

number | null // Stored as total seconds, e.g., 3600 (1 hour), 7260 (2:01:00), null

"duration"

{
  "name": "Meeting Length",
  "template": {
    "format": "h:mm:ss"         // "h:mm" | "h:mm:ss" | "h:mm:ss.s" | "h:mm:ss.ss" | "h:mm:ss.sss", default: "h:mm"
  }
}

string | null // Option label, e.g., "Active", "Pending", null

"single_select"

{
  "name": "Status",
  "template": {
    "options": [
      { "label": "Active", "color": "green" },
      { "label": "Inactive", "color": "gray" },
      { "label": "Pending", "color": "yellow" }
    ]
  }
}

string[] // Array of option labels, e.g., ["Urgent", "Bug"], []

"multiple_select"

{
  "name": "Tags",
  "template": {
    "options": [
      { "label": "Urgent", "color": "red" },
      { "label": "Bug", "color": "orange" },
      { "label": "Feature", "color": "blue" },
      { "label": "Enhancement", "color": "purple" }
    ]
  }
}

boolean // true or false

"checkbox"

{
  "name": "Is Complete",
  "template": {
    "color": "#10b981"          // default: "#a8a4ac"
  }
}

string | null // ISO date string (UTC), e.g., "2024-03-15T00:00:00.000Z", null

"date"

{
  "name": "Due Date",
  "template": {
    "dateFormat": "us"          // "local" | "long" | "us" | "european" | "iso", default: "local"
  }
}

string | null // ISO datetime string, e.g., "2024-03-15T14:30:00.000Z", null

"datetime"

{
  "name": "Meeting Time",
  "template": {
    "displayTimeZone": true,    // default: false
    "dateFormat": "us",         // "local" | "long" | "us" | "european" | "iso", default: "local"
    "timeFormat": "24h",        // "12h" | "24h", default: "12h"
    "timezone": "America/New_York" // default: "" (browser timezone)
  }
}

Array<{
  url: string,          // Required: URL to the file
  filename?: string     // Optional: Display name for the file
}>

"attachments"

string[] // Array of record IDs, e.g., ["rec123", "rec456"] or []

"linked_record"

{
  "name": "Related Tasks",
  "template": {
    "tableId": "tbl789",        // required: ID of table to link to
    "allowMultiple": true,      // default: true
    "inverseFieldId": "fld456", // optional: ID of inverse field
    "isInverse": false          // optional: flag for inverse fields
  }
}

any | any[] | null
// Returns the actual values from the looked-up field
// Single value if linked record field has allowMultiple: false
// Array of values if linked record field has allowMultiple: true
// Type depends on the field being looked up (string, number, boolean, etc.)

"lookup"

{
  "name": "Task Names",
  "template": {
    "linkedRecordFieldId": "fld123", // required: ID of linked record field in same table
    "lookupFieldId": "fld456"        // required: ID of field to lookup in linked table
  }
}

string | number | Date | boolean | any[]  // Based on resultType

"formula"

{
  "name": "Total Price",
  "template": {
    "expression": "SUM({Price}, {Tax})",
    "resultType": "number",
    "formatting": {
      "numberDisplayType": "currency",
      "decimalPlaces": 2
    }
  }
}

number | null  // e.g., 1, 2, 3, ... (auto-assigned by the system)

"autonumber"

{
  "name": "ID",
  "template": {}  // No configuration options
}

// Discriminated union based on `type`
| { type: "public_api", apiKeyId?: number }
| { type: "form_submission", flowPublicId: string, sessionId: string }
| { type: "workflow", workflowId: string, executionId: string }
| { type: "manual", reason?: string, userId?: number }
| null

"source"

{
  "name": "Source",
  "template": {}  // No configuration options
}