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

icon picker
Linked Columns In Coda

Connor McCormick
⁠
Loading…
⁠
⁠

This is the simplest way to implement linked columns in Coda.
See the discussion in the community
⁠
.

Easily add this to your doc with the
Formula Generator
⁠


Handle the edge case where the local column is blank
Get all the destination rows that will need to be modified. This is a combination of all destination rows referenced in this row, plus all the times this row was referenced in the destination.
Filter down to only single instances of each row
Modify each row in the destination table such that it contains all the places where this table mentions that row

RunActions(
thisRow.ModifyRows(thisRow.SourceColumn,
If(thisRow.SourceColumn.IsBlank(), '',
thisRow.SourceColumn.Filter(Dest.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))
)
)
)
)


Source
Name
SourceColumn
Button | Update
1
A
X
Y
Update
2
B
X
Y
Z
Update
3
C
X
Update
There are no rows in this table
⁠

Target
Name
TargetColumn
Button | Update
1
X
A
B
C
Update
2
Y
A
B
Update
3
Z
B
Update
There are no rows in this 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.