Sheets

Info

The Sheets building block is designed to map a specific range of a Google Sheet into a Coda table.

Parameters

Is Header First Row : check this on if your data range has a header with column names. this way, these data will be only used as column names. Default is false , so it’s assumed that the first row will be with headers.

Transpose : check this on if you want to translate columns into rows (and vice versa). Default is false. When set to false the pack will assume the data is arranged into a table-like structure.

Range: the range of cells in typical A1Notation. Default is blank , meaning all the cells of the selected tab

Row Range Usage

Having access to the range of each row will make it much easier to use UpdateRow() as it wants that range as one of it’s parameters.

Example

See

Manage your sync⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.