Formula: ‘=AutoDiagramOfCodaDatabase()’ Automatically creates a diagram of how your coda tables are connected.
Sync Table: ‘/AllTablesInCodaDocument’ creates a synced table were every row is a table in your coda document.
Sync Table: ‘/AllColumnsInCodaDocument’ creates a synced table were every row is a column in your coda document.
(Note this pack uses the API and can only reference saved changes. You can only save changes in your own copied document. In order to give it a try, copy the doc for yourself and enjoy the free trial.)
Test Data: Event Management Database
Events
1
2
3
Event Name
Attendees
Locations
Event Name
Attendees
Locations
Event 1
Person 1
Person 2
Location 1
Event 2
Person 2
Person 3
Location 2
Event 3
Person 1
Location 3
There are no rows in this table
People
1
2
3
Person Name
Events Attended
Person Name
Events Attended
Person 1
Event 1
Event 3
Person 2
Event 1
Event 2
Person 3
Event 2
There are no rows in this table
Locations
1
2
3
Location Name
Related Events
Location Name
Related Events
Location 1
Event 1
Location 2
Event 2
Location 3
Event 3
There are no rows in this table
Examples
1. Auto Diagram of Coda Database
Notice how the below diagram perfectly represents the “Events Management” database above.
And it was generated automatically!
Connect to Auto Database Diagrams in Coda
The above diagram is created using the simple formula in the screenshot below.
FAQ 1: ‘How to create your own synced diagrams’
Since this pack uses the API it can only see saved changes in your documents. To get started:
Click the
Copy doc
button.
Create a diagram using the following formula
=
Create an API Key with Coda Prompts you. Name it anything you like.
Note: Adding restrictions may affect the pacts ability to automatically find the DocumentId’s for you.
PS: I will never have access to your documents
Enjoy Your Synced Diagram!
Connect to Auto Database Diagrams in Coda
FAQ 2: ‘How to diagram more then 1 coda document?’
Easy. First create a copy click doc.
Copy doc
For each diagram simply use the following formula:
(Remember to select a different doc in the second parameter)
=
Sync Tables
Notice how the below tables tell you about the “Events Management” database above.
And it was generated automatically!
2. All tables in coda document
1
Connect your account to refresh data from Auto Database Diagrams in Coda.
All tables in coda document
Table name
i
Table id
i
Row count
i
Type
i
Table type
i
Layout type
i
Is sync table
i
Location type
i
Location name
i
Location id
i
Browser link
i
Api link to table
i
Parent table name
i
Parent table id
i
Synced
Sync account
All tables in coda document
Table name
i
Table id
i
Row count
i
Type
i
Table type
i
Layout type
i
Is sync table
i
Location type
i
Location name
i
Location id
i
Browser link
i
Api link to table
i
Parent table name
i
Parent table id
i
Synced
Sync account
1
Events
grid-FtGYLwKYey
4
table
table
default
page
Example: Auto Database Diagrams in Coda
canvas-ZzrZoNsQvp
Logan Krantz (1)
2
People
grid-2TJiBv-Moe
3
table
table
default
page
Example: Auto Database Diagrams in Coda
canvas-ZzrZoNsQvp
Logan Krantz (1)
3
Locations
grid-F6QgrSgNZv
3
table
table
default
page
Example: Auto Database Diagrams in Coda
canvas-ZzrZoNsQvp
Logan Krantz (1)
No results from filter
3. All columns in coda document
Connect your account to refresh data from Auto Database Diagrams in Coda.
FAQ 3: ‘How to create your own synced database tables?’
Since this pack uses the API it can only see saved changes in your documents. To get started:
Click the
Copy doc
button.
Create a diagram using the following command:
When you create a Coda API Key name it anything you like.
Note: Adding restrictions may affect the pacts ability to automatically find the DocumentId’s for you.
PS: I will never have access to your documents
Enjoy Your Synced Diagram Table!
All tables in coda document
1
Connect your account to refresh data from Auto Database Diagrams in Coda.
Is sync table
Search
All tables in coda document
Table name
i
Row count
i
Browser link
i
All tables in coda document
Table name
i
Row count
i
Browser link
i
1
Events
4
2
People
3
3
Locations
3
4
2. All tables in coda document
5
5
3. All columns in coda document
38
There are no rows in this table
FAQ 4: ‘How to synced with more then 1 coda document?’
Easy. First create a copy click doc.
Copy doc
Click the ‘Settings’ button on the top of the sync table and then the ‘+ Add another sync’ button.