Loading Tables

All of the building blocks require you to specify which tables you want to load before you start running queries against them. The load parameter takes a list of strings, each of which specifies a table. However there are many ways to specify a table, including some advanced options

Pick from a list

When using the QueryTable sync table, the load parameter will show a list of tables in the current doc that you can select from. Simply check off the tables you wish to load.

⁠

Enter manually

When using one of the formulas, or when you wish to use more advanced options in the QueryTable sync table, you must pass the tables using the List() formula.

QueryGrid(

<Account>,

List("Employees", "table-0pjojhpaNL"),

Query

)

Table specification options

Table specification options

Name

Example

Notes

Table name

Employees

Simply enter the name of the table.

Table ID

table-0pjojhpaNL

To find the table ID, enable developer mode to add a “Copy table ID” and “Copy view ID” option to the table three dots menu. Table IDs remain the same even when the name changes. In SQL refer to the table by it’s name.

Across docs

Formulas@r1bd2j1AMC

To reference a table from another doc, append the table name with @{Doc ID} , where {Doc ID} is the ID of the other doc. You can find the doc’s ID in the URL after _d :

https://coda.io/d/My-Doc_d123456/My-Page_su789

Set SQL table name

table-0pjojhpaNL=>Employees

If you want to use a different name of the table in SQL, append the table name with =>{Name} , where {Name} is the name you want to load it into.

This is particularly useful when you are loading tables by

@Table ID

⁠

to prevent against queries breaking when tables are renamed, or when querying

@Across docs

⁠

and you have multiple tables with the same name.

There are no rows in this table

⁠

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.