Skip to content
Formula Generator
This generator allows you to easily implement linked columns in Coda in 4 steps:
Generate the formula
Add the names of your tables and columns:
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 and add a button column.
Source
Use ⌘ + Shift + V to paste (as text) this inside the button’s formula box.
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.
Link the next one
Now, to link the other direction (from in back to in ), click this button and, again, follow the instructions under Copy this.
TargetColumn
Target
SourceColumn
Source
Swap
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.