Introduction

See how your coda docs fit together

This pack helps you analyse your coda documents.

Test Data: Event Management Database

Examples

1. Auto Diagram of Coda Database

Notice how the below diagram perfectly represents the “Events Management” database above.

And it was generated automatically!

⁠

⁠

⁠

⁠

⁠

⁠

FAQ 1: ‘How to create your own synced diagrams’

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 ​

⁠

⁠

⁠

⁠

⁠

FAQ 2: ‘How to diagram more then 1 coda document?’

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

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

3. All columns in coda document

0

Connect your account to refresh data from Auto Database Diagrams in Coda.

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

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?’

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 ​

⁠

⁠

All tables in coda document

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?’

⁠

⁠

⁠