Share
Explore

autodatabase
Example: Auto Database Diagrams in Coda

Introduction

info

See how your coda docs fit together

This pack helps you analyse your coda documents.

(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: ​
image.png

Test Data: Event Management Database

Events
1
2
3
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 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 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

light

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

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 =
image.png
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 ​
image.png
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) =
image.png

Sync Tables

info

Notice how the below tables tell you about the “Events Management” database above.

And it was generated automatically!
image.png
(Note: The above is a picture but you can ceare your own ‘All coda document’ synced table. Try ‘Copy This Doc’ to get started)
3. All tables in coda document
1
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
4. All columns in coda document
Table name
i
All columns in coda document
Table type
i
Table id
i
Is sync table
i
Column name
i
Column id
i
Column data type
i
Is display column
i
Is column calculated
i
Column formula
i
Column drop down type
i
Lookup table name
i
Lookup table id
i
Api link to column
i
Events
3
table
grid-FtGYLwKYey
Event Name
c-qynWKpwzUB
text
table
grid-FtGYLwKYey
Event Attendees
c-KWbfXMemi2
lookup
Multi Select
People
grid-2TJiBv-Moe
table
grid-FtGYLwKYey
Event Locations
c-YU3OA-0Q1W
lookup
Single Select
Locations
grid-F6QgrSgNZv
People
2
table
grid-2TJiBv-Moe
Person Name
c-IoXCkIc6J9
text
table
grid-2TJiBv-Moe
Attended
c-Uec4hdwLQV
lookup
Events.Filter([Event Attendees].Contains(thisRow))
Multi Select
Events
grid-FtGYLwKYey
Locations
2
table
grid-F6QgrSgNZv
Location Name
c-mzS9mYFTUM
text
table
grid-F6QgrSgNZv
Related Events
c-Hv6X8W2J1x
lookup
Events.Filter([Event Locations].Contains(thisRow))
Multi Select
Events
grid-FtGYLwKYey

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: ​
image.png
image.png
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 ​
image.png
Enjoy Your Synced Diagram Table!
All tables in coda document
1
Search
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.
image.png

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.