Skip to content
More
Share
Explore
Bi directional table links
Bi directional table links
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
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.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.