(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.)
There are a few main building blocks
Formula: ‘=AutoDiagramOfCodaDatabase()’ Automatically creates a diagram of how your coda tables are connected.
Sync Table: ‘/AllCodaDocuments’ creates a synced table were every row is a doc that you have access to.
Sync Table: ‘/AllTablesInCodaDocument’ creates a synced table were every row is a table from one or more of your coda document.
Sync Table: ‘/AllColumnsInCodaDocument’ creates a synced table were every row is a column from one or more of your coda document.
An example diagram would look like this:
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!
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!
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!
(Note: The above is a picture but you can ceare your own ‘All coda document’ synced table. Try ‘Copy This Doc’ to get started)
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
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.