Skip to content
Gallery
Linked Columns
Linked Columns In Coda
Formula Generator
More
Share
Explore

icon picker
Formula Generator

This generator allows you to easily implement linked columns in Coda in 4 steps:
Generate the formula
Copy paste the formula into your doc
Do steps 1 & 2 for the second column

Generate the formula

Add the names of your tables and columns:
⁠
Source
⁠
this is the name of your equivalent to the table
Source
⁠
⁠
SourceColumn
⁠
your equivalent to SourceColumn in the
Source
⁠
table
⁠
Target
⁠
the name of your target table. Like
Target
⁠
in
this doc
⁠
⁠
⁠
TargetColumn
⁠
the name of your TargetColumn in
Target
⁠
(which is like
Target
⁠
in
this doc
⁠
)
⁠
Clear Names
⁠
⁠

Copy this

⁠
RunActions( thisRow.ModifyRows(thisRow.[SourceColumn], If(thisRow.[SourceColumn].IsBlank(), '', thisRow.[SourceColumn].Filter([Target].Contains(CurrentValue)) ) ), [Target].Filter([TargetColumn].Contains(thisRow)).IfBlank(List()).ListCombine( thisRow.[SourceColumn].IfBlank(List())).Unique().FormulaMap( WithName(CurrentValue, Row, Row.ModifyRows([TargetColumn], thisTable.Filter([SourceColumn].Contains(Row)) ) ) ) )
⁠
⁠
To copy, put with your mouse here ☝️ and click and drag up to highlight the formula block.
Press ⌘ + C to copy.

Paste the formula

Go to your table
Source
⁠
and add a button column.
Use ⌘ + Shift + V to paste (as text) this inside the button’s formula box.
⁠
image.png
⁠
⁠

Optional: Add automatic updates

For each table, add this sort of automation. All it’s doing is automatically clicking the Update button each time the row is changed.
⁠
image.png
⁠
⁠

Link the next one

Now, to link the other direction (from
TargetColumn
⁠
in
Target
⁠
back to
SourceColumn
⁠
in
Source
⁠
), click this button and, again, follow the instructions under Copy this.
Swap
⁠
⁠
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.