Skip to content
Linked Columns
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
SourceColumn
your equivalent to SourceColumn in the table
Target
the name of your target table. Like in
TargetColumn
the name of your TargetColumn in
Target
(which is like in )
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.