Explore

Example: Auto Database Diagrams in Coda

Introduction

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:

⁠

Test Data: Event Management Database

Events

Events

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

People

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

Locations

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)

3. All tables in coda document

3. All tables in coda document

All tables in coda document

Table name

Table id

Row count

Type

Table type

Layout type

Is sync table

Location type

Location name

Location id

Browser link

Api link to table

Parent table name

Parent table id

Synced

Sync account

Events

grid-FtGYLwKYey

table

default

page

Example: Auto Database Diagrams in Coda

canvas-ZzrZoNsQvp

Logan Krantz (1)

People

grid-2TJiBv-Moe

table

default

page

Example: Auto Database Diagrams in Coda

canvas-ZzrZoNsQvp

Logan Krantz (1)

Locations

grid-F6QgrSgNZv

table

default

page

Example: Auto Database Diagrams in Coda

canvas-ZzrZoNsQvp

Logan Krantz (1)

No results from filter

⁠

4. All columns in coda document

4. All columns in coda document

Table name

All columns in coda document

Table type

Table id

Is sync table

Column name

Column id

Column data type

Is display column

Is column calculated

Column formula

Column drop down type

Lookup table name

Lookup table id

Api link to column

Events

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

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

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:

⁠

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