type string, value shape, and key settings (defaults in parentheses). Every key setting is optional, except where marked required.
Notes
numberFormat:local(default) ·comma_period·period_comma·space_comma·space_period·no_separator.- Duration
format:h:mm(default) ·h:mm:ss·h:mm:ss.s·h:mm:ss.ss·h:mm:ss.sss. options[]:labelrequired;coloroptional (auto-assigned if omitted);valueoptional, so omit it when creating. On update, options merge into the existing ones; see Update Field. Colors: purple, orange, blue, gray, red, yellow, green, pink, lime, tangerine, emerald, sky, teal, indigo, cyan, violet, fuchsia.dateFormat:local(default) ·long·us·european·iso.timeFormat:12h(default) ·24h.tableIdtakes a table ID. When you create a database or a table, it also accepts the name of a table in that database; Create Field takes IDs only. Creating the field auto-connects both tables in both directions.- Single value if the linked-record field has
allowMultiple: false, array iftrue; element type matches the looked-up field. - Lookups and rollups can’t be created while creating a database or table. Add them afterwards with Create Field.
linkedRecordFieldIdandlookupFieldId/rollupFieldIdtake field IDs. { type: "public_api", apiKeyId? }|{ type: "form_submission", flowPublicId, sessionId }|{ type: "workflow", workflowId, executionId }|{ type: "manual", reason?, userId? }|null.- With
allowMultiple: falsethe value is still an array, capped at one ID.internalOnlyonly limits the picker in the app UI to organization members.deleteRowWhenUserDeleteddeletes the record when its user is removed, and only applies whenallowMultipleis off.
Formula fields
Formula fields compute their value from other fields using a formula expression. They are read-only and automatically recalculate when referenced fields change. See the Formulas guide for the complete list of supported functions.
Formatting options
- Numbers use
numberDisplayType:"number"(plain) ·"currency"(use withdecimalPlaces,numberFormat) ·"percent"·"duration". - Dates use
dateFormat,timeFormat("12h"or"24h"),timezone,displayTimeZone(whether to show the timezone).
Primary field
The first field in each table is the primary field and must be one of:single_line_text, long_text, date, datetime, phone_number, email, url, number, currency, percent, duration, autonumber, formula.