Tables

Create, update and/or delete records in a custom table, one or many per call.

Create a new record in a custom table

Update fields on an existing record in a custom table

Delete a record from a custom table

Search records in a custom table by free text and/or structured filters (numeric, date, enum conditions).

List the custom data tables in this organization.

Get the columns (field schema) of a custom table.

Get a single record from a custom table by id.

List the saved views across custom tables, with each view's filter, sort and config.

Run a saved view and return its records (paginated). Board views REQUIRE 'group' (an option value of the group-by field); calendar and timeline take a date window.

Create a new custom data table. If a similarly named table may already exist, check List Tables first and confirm with the member before creating a duplicate. New tables start with SYSTEM fields only (id, timestamps) — no name or text column exists until you create it. Add ALL the member's columns (including a name/title text field) with 'TABLES:MANAGE_FIELDS' right after.

Update a custom table: rename, change the description, set the display field, or archive it. Only provided inputs change.

Permanently delete a custom table with all its records, fields and views. Irreversible; archive the table instead to hide it.

Create and/or update columns on a custom table, one or many per call.

Reorder a column: move a field before or after a sibling field (pass exactly one of before/after).

Permanently delete a column and its values from a custom table. Irreversible; archive the field instead to hide it.

Create a saved view on a custom table. Board, calendar and timeline views need a group-by field key.

Update a saved view: rename, change sort, filter or grouping, or archive it. Only provided inputs change.

Delete a saved view from a custom table (a table always keeps at least one view).

Copy a saved view (layout, filter, sort and config) as a new view on the same table.

Move a record inside a saved view: place it after or before a sibling record id (at least one required; use before with the first item to move it first) and, on board views, change its group (group_value).

List a board view's groups in display order (the valid 'group' values for Get View Items and Move View Item).

Compute a metric over the records of a saved view: count, sum/avg/min/max of a number field, optionally grouped by a field, windowed by date, filtered, or compared to the previous period. Much cheaper than fetching rows to count them.

Reorder a table's saved views: pass the view ids in the desired order (tab order in the UI).