Skip to main content
create_table Create a new table (database / spreadsheet) in a project with a name and its columns. The name must be unique in the project and column names unique within the table. At most ONE column may have isIdentifier: true — the row label / primary key (a person’s name, a product title). Without one, an identifier column named “ID” is added. Column types: string, number, money, date, time, checkbox, select, multiSelect, email, url, phone, location, linkCell, oneMany, computed, reference, timer, approval, person, progress. For select/multiSelect columns: provide selectOptions (array of label strings) so the dropdown is pre-populated. For oneMany (relation) columns: provide linkedTableId (the _id of an existing table in the same workspace). For progress columns: provide progress (mode, total, unit, display). For computed columns: create the column, then use set_computed. The table starts with no rows; add them with add_row or add_row_batch.

​
Parameters

​
string
required
Table name, unique within the project.
​
string
​
array<object>
required
Columns to create, in order. At most one may have isIdentifier: true — it acts as the row label / primary key.
​
string