Bi directional table links

⁠

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

Ko-fi here.⁠

⁠

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

Invoices with Line items

1001

Customer 01

1002

Customer 02

1001

Customer

Customer 01

Line item details

Inv Detail

Inv Detail

Product

Product

Amount

Amount

Widget 1

Widget 2

There are no rows in this table

Total

⁠

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.