Skip to content
Linked Columns
Share
Explore

Formula Generator

I use this a lot. It’s not fun to copy the formula and manually replace all the column and table names.
This generator makes it easy.
By default, it generates a formula for the tables in , but you can rename the variables to your own Table and Column names.
Input names of your tables
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
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.