Advanced Fields

Nine specialized field types cover computed values, generated identifiers, interactive controls, and structured data. This page also documents barcode (a media-category field). All share the base field properties.

Type	Stores / does
formula	A value computed from a formula expression.
count	A count of related records.
autonumber	An auto-incrementing number with prefix and zero-padding.
button	An interactive button triggering a URL or automation.
json	Structured JSON data.
array	An array of typed values.
color	A hex color value.
code	Source code with syntax highlighting.
geolocation	Latitude/longitude coordinates.
barcode	A barcode value (media category — see below).

formula

Computes a value from a formula expression referencing other fields.

Property	Description
formula	Required. Expression to compute. Supports field references, operators, and functions.
resultType	Expected data type of the result (e.g. string, number, boolean, date).
format	Display format for the result (e.g. currency, percentage, decimal, date).

- { id: 1, name: total_price, type: formula, formula: 'price * quantity', resultType: number }

count

Counts the number of records linked through a relationship field in the same table. A simplified rollup.

Property	Description
relationshipField	Required. Name of the relationship field whose linked records to count.
filters	Optional filter expression — count only matching linked records.

- {
    id: 2,
    name: completed_task_count,
    type: count,
    relationshipField: tasks,
    filters: { field: status, operator: equals, value: completed },
  }

autonumber

An auto-incrementing number with an optional prefix and zero-padding.

Property	Description
prefix	Optional text prepended to the number (e.g. INV-, ORD-).
startFrom	Starting number (integer ≥ 1).
digits	Minimum digit count with zero-padding. Integer from 1 to 10.

- { id: 3, name: invoice_number, type: autonumber, prefix: 'INV-', startFrom: 1000, digits: 5 }

button

An interactive button rendered on records that triggers an action.

Property	Description
label	Required. Button text.
action	Required. Type of action to trigger (e.g. url, automation).
url	URL to open (when action is url).
automation	Automation name to run (when action is automation).

- {
    id: 4,
    name: approve,
    type: button,
    label: Approve,
    action: automation,
    automation: approve_request,
  }

json

Stores structured JSON data with optional schema validation.

Property	Description
schema	Optional JSON Schema object for validating contents.

- { id: 5, name: metadata, type: json, required: false }

array

Stores an array of values with optional type and length constraints.

Property	Description
itemType	Data type of array elements (e.g. string).
maxItems	Maximum number of elements (integer ≥ 1).

- { id: 6, name: tags, type: array, itemType: string, maxItems: 10 }

color

Stores a color value in hexadecimal format. Rendered with a color picker.

Property	Description
default	Default color as a 6-digit hex value (e.g. #3B82F6).

- { id: 7, name: brand_color, type: color, required: true, default: '#3B82F6' }

code

Stores source code as plain text with syntax highlighting (CodeMirror 6).

Property	Description
language	Required. Language for highlighting (e.g. javascript, typescript, yaml, json, python, sql, html, css, markdown).
lineNumbers	Boolean. Show line numbers.
readOnly	Boolean. Make the editor read-only.
minLines	Minimum visible lines (integer ≥ 1).
maxLines	Maximum visible lines before scrolling (integer ≥ 1).
tabSize	Tab size in spaces. Integer from 1 to 8 (default 2).

- { id: 8, name: snippet, type: code, language: typescript, lineNumbers: true, tabSize: 2 }

geolocation

Stores geographic coordinates (latitude and longitude) for location-based features. Takes no type-specific properties beyond the base field properties.

- { id: 9, name: office_location, type: geolocation, required: true }

barcode

Stores a barcode value for product identification and inventory. (Categorized under media, documented here with the other specialized value fields.)

Property	Description
format	Barcode format (e.g. EAN-13, CODE128).

- { id: 10, name: product_barcode, type: barcode, required: true, format: EAN-13 }