Skip to content
Gallery
The Notion User's Guide to Coda
The Notion User's Guide to Coda
Using the Importer
Tips for making the most of Coda
Before / After
More
Share
Explore
Tables & Views

icon picker
Coda Lookups Example

Here's a quick example of translating Relations and Rollups from Notion into Lookups in Coda.
I have two tables I want to relate to one another: Projects and Tasks. I also want to pull in the number of tasks associated with each Project.
In Notion this means I create a Relation column in the Projects table which relates to the Tasks table. Then I add a Rollup to count the number of tasks related to each project. The setup looks like this.

⁠
Loading…
⁠
⁠
In Coda, I have two very similar looking tables. To relate the Tasks table to the Projects table, I add a Lookup column to the Projects table which looks up rows (entries) in the Tasks table. To summarize the Projects which reference each task in the Tasks table, I use a formula column to filter entries of the Projects table. Finally, to show the number of tasks associated with a project, I use a formula to count the number of tasks selected in the Lookup column.
💡 Tip: Copy this doc so you can play around with it (it’s free!). Then, click on any column header in the tables below to see its configuration, including column type and formulas. You can also expand the text below these tables for a GIF showing how I set this up!
Projects
Name
Tasks
Number of Tasks
1
Project 1
Task A
Task B
2
2
Project 2
Task C
1
3
Project 3
​
0
There are no rows in this table
⁠
Tasks
Name
Associated Project
1
Task A
Project 1
2
Task B
Project 1
3
Task C
Project 2
There are no rows in this table
⁠

Expand to see how I set this up in!

⁠
Loading…
⁠
⁠
⁠
By default, if you import this setup to Coda from Notion, both the Tasks and Associated Project columns will be Lookups. This means that changing one will not change the other. Since Coda links are mono-directional, this allows you to choose which side should be the input (the Lookup) and which should be a summary (the formula). In the example above, it makes sense to select tasks for a given project in the Projects table and to summarize the lookup in the Tasks table.

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.