icon picker
Bi directional table links

image.png
If you find this document useful, please consider buying me a

Bi directional links between tables in Coda is possible. It does not work in the way that it does in other products, but it is possible.
In the example below, I have an invoice header and a detail table.
In the Item table, the Inv Nr is a lookup from the header table. The item table also has a column, that copies the text of the Lookup column into the Hid Inv Nr field. In the Header table I filter on the Hid Inv Nr field.
End result is a header table with a list of the Details rows for each Invoice. And a detail table with the invoice details per Invoice Number.
Invoices with Line items
1
Search
1001
Customer 01
1002
Customer 02
1001
Customer
Customer 01
Line item details
1
2
Inv Detail
Product
Amount
10
Widget 1
10
20
Widget 2
20
There are no rows in this table
Total
30
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.