TablesRead-only

Check a formula before saving it

validate_table_formula

Compile a formula (or a Lookup / Rollup / Count preset) against the workspace’s real schema WITHOUT saving it: reports whether it parses, what type it returns, which fields it depends on, how many relation hops it makes, and whether it is volatile (time-dependent). An invalid draft is an ANSWER here, not an error — use it before add_table_field.

Parameters

Parameter	Type	Required	Description
`tableId`	string	required	Table the formula belongs to
`source`	string	optional	Formula source to check — fields are `{fld:<fieldId>}`, from get_table
`preset`	object	optional	Structured preset to check instead
`fieldId`	string	optional	The field being edited, when checking a change to an existing formula
`sampleRows`	integer	optional	Rows to evaluate it against (default 3, 0 = compile only)

Example call

The tool call an MCP client sends (required arguments shown with placeholder values).

{
  "tool": "validate_table_formula",
  "arguments": {
    "tableId": "tableId_123"
  }
}

Use this tool in

Claude Code Claude Desktop Claude Cowork ChatGPT Cursor Windsurf VS Code Copilot OpenClaw Gemini Hermes Agent

Related Tables tools

List tableslist_tablesList the tables in the workspace (id, name, kind — typed or custom — resource type, fields, row count, schema/revision versions).Get tableget_tableGet one table by id: its full field set (key, label, kind, display format, select options, whether the field is feed-owned and whether it can be written), the fields that form row identity, the promoted primary/date/amount bindings, row count, and its schema badge.Create tablecreate_tableCreate a table in the workspace.Update tableupdate_tableUpdate a table’s METADATA — name, icon, retention policy.

← All tools