Gallery
Subtasks in Coda
Share
Explore

icon picker
Example Two

Two tables...connected!

This approach involves:

Two tables (one for your larger unit of work, one for the sub-items)
Connecting these two tables via a
the tasks table by the project column

Table 1: Projects
Project Name
Owner
Status
Due Date
1
EcoBoost
Adam Davis
Not Started
1/31/2023
2
SmartHomes
Jason Allenstein
In Progress
2/15/2023
3
Cloud9
Lola Tseudonym
Complete
2/28/2023
There are no rows in this table
Table 2: Tasks
Project (relation column)
Task name
Task owner
Done?
EcoBoost
3
Task A
Maria Marquis
Task B
Jason Allenstein
Task C
Alan Chowansky
SmartHomes
3
Task D
Buck Dubois
Task E
Mary Jones
Task F
James Booth
Cloud9
3
Task G
Mary Jones
Task H
Polly Rose
Task I
Joel Davis

light
Connecting tables in Coda with relation columns allows you to build docs more efficiently. Instead of writing all your project names again in the task table, a relation column lets you reference your list of projects that already exists in
AND if you make a change to the name of one of these projects, that change will reflect in the relation column as well. Try it out.
light
Connecting tables via relation columns is not the same as creating a
of a table.
Relation columns are like a window to the rows of another table. We are “relating” a column to another table.
A View is a mirror of a table’s data that can be tailored to your unique needs, all while staying connected to the source.

Next →

Share
 
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.