Handbook · Reference · Blockly · Table
Blockly: Table
Where in the UI. Scripts tab toolbox.
CTBL / file-table rows, CSV, columns.
| Block id | Read as | Purpose |
|---|---|---|
containd_append_table_row | append table row | values list order must match table columns; host coerces types |
containd_set_table_row | set table row | overwrite row at 0-based index; same list shape as append |
containd_remove_table_row | remove table row | remove row at 0-based index and persist |
containd_clear_table | clear table | remove all rows; column schema unchanged |
containd_set_table_rows | set table rows | replace all rows from a 2D list (inverse of table rows); host coerces types |
containd_get_table_row_count | get table row count | callHost(getTableRowCount).value.rowCount |
containd_get_table_row_count_on_item | get table row count on item | callHost(getTableRowCount) with itemId — accepts numeric id or ItemRef; requires read.relatives when not bound item |
containd_get_table_columns | get table columns | returns column id strings in schema order |
containd_get_table_columns_on_item | get table columns on item | callHost(getTableMeta) column ids with itemId — accepts numeric id or ItemRef; requires read.relatives when not bound item |
containd_get_table_headers | get table headers | localized header labels in column order |
containd_get_table_headers_on_item | get table headers on item | callHost(getTableMeta) headers with itemId — accepts numeric id or ItemRef; requires read.relatives when not bound item |
containd_get_table_column_types | get table column types | type strings (string/int/double/timestamp/color) |
containd_get_table_column_types_on_item | get table column types on item | callHost(getTableMeta) column types with itemId — accepts numeric id or ItemRef; requires read.relatives when not bound item |
containd_get_table_meta_max_rows | get table meta max rows | callHost(getTableMeta).value.maxRows |
containd_get_table_meta_max_rows_on_item | get table meta max rows on item | callHost(getTableMeta).value.maxRows with itemId — accepts numeric id or ItemRef; requires read.relatives when not bound item |
containd_get_table_rows | get table rows | 2D list of all rows (column order) |
containd_get_table_rows_on_item | get table rows on item | callHost(getTableRows) with itemId — accepts numeric id or ItemRef; requires read.relatives when not bound item |
containd_table_to_csv | table to csv | CSV string for this table/fileTable property (pick property when item has multiple tables) |
containd_table_to_csv_on_item | table to csv on item | callHost(tableToCsv) with itemId — accepts numeric id or ItemRef; requires read.relatives when not bound item |
containd_get_table_row | get table row | one row as a list at 0-based index |
containd_get_table_row_on_item | get table row on item | callHost(getTableRow) with itemId — accepts numeric id or ItemRef; requires read.relatives when not bound item |
containd_create_empty_table_row | create empty table row | list of nulls matching column count (fill then append/set) |
containd_create_empty_table_row_on_item | create empty table row on item | callHost(createEmptyTableRow) with itemId — accepts numeric id or ItemRef; requires read.relatives when not bound item |
containd_extract_table_column | extract table column | flat row-ordered values list (timestamp cells are epoch ms) |
containd_extract_table_column_on_item | extract table column on item | callHost(extractTableColumn) with itemId — accepts numeric id or ItemRef; requires read.relatives when not bound item |
containd_set_table_column | set table column | values list length must equal row count; host coerces types |