Skip to content
Table SQL Pack - User Guide
Share
Explore
Get starts with the Table SQL Pack for Coda

icon picker
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.
image.png

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
0
Name
Example
Notes
1
Table name
Employees
Simply enter the name of the table.
2
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.
3
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
4
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.