How to Create Relationships Between Tables in Coda

Learn how to link tables in Coda using Lookup columns so rows in one table can reference and pull data from another.

Quick answer

To create relationships between tables in Coda, open your document, click the plus icon on a table to add a new column, choose Lookup from the column type menu, select the table you want to reference, then configure the relation to link matching rows between both tables automatically.

Steps at a glance

  1. Open the table where you want to add a relationship
  2. Click the + icon to add a new column
  3. Choose Lookup as the column type
  4. Select the table you want to reference
  5. Pick a matching row for each entry
  6. Enable 'Display as reference chips' if desired
  7. Repeat on the other table for a two-way link

Summary

Relationships in Coda connect rows across two separate tables using a Lookup column, letting you reference records like projects, people, or tasks without duplicating data. This keeps information consistent across your doc and powers features like rollups and cross-table formulas.

Step-by-step guide

  1. Step 1

    Open the table that needs the relationship

    Navigate to the table where you want rows to reference another table, such as a Tasks table that needs to point to a Projects table. If you haven't built both tables yet, start by using the guide for how to add rows to a table so you have data to connect.

  2. Step 2

    Add a new column

    Click the + icon at the far right of the table's column headers to insert a new column. This opens the column type menu where you'll pick how the new column behaves.

  3. Step 3

    Select Lookup as the column type

    Scroll through the column type list and choose Lookup. This tells Coda the column will reference rows from a different table rather than store plain text or numbers.

  4. Step 4

    Choose the table to reference

    Coda will show a list of tables in your doc. Select the one you want to link to, for example Projects, so each row in your current table can point to a matching row there.

  5. Step 5

    Assign values to each row

    Click into the new column for any row and pick the matching record from the referenced table. Repeat this for each row that needs a relationship, or bulk-assign by dragging the same value down multiple cells.

  6. Step 6

    Adjust display and reverse lookup options

    Open the column's settings menu to toggle options like showing the reference as a chip, allowing multiple selections, or creating a reverse lookup column on the referenced table. A reverse lookup lets the Projects table show all linked Tasks automatically.

  7. Step 7

    Use the relationship in formulas or views

    Once connected, you can reference linked data directly in formulas, use it in a lookup column setup, or filter a view based on the related table's values. This is especially useful when building dashboards that combine data from multiple tables.

Why this matters

You're building a project tracker where each task needs to show its parent project, owner, and status pulled from other tables. Setting up table relationships lets you reference that data live instead of retyping it, so updates in one place stay accurate everywhere else in your doc.

Frequently asked questions

  • Can I link more than two tables together in Coda?

    Yes. You can create multiple Lookup columns across several tables, so a single table can relate to two, three, or more other tables at once, each through its own column.

  • Does creating a relationship duplicate the data?

    No. A Lookup column references the original row rather than copying its contents, so any edit to the source row automatically reflects everywhere it's linked.

  • What's the difference between a Lookup column and a reverse lookup?

    A Lookup column lets one table point to rows in another table. A reverse lookup is the automatically generated column on the referenced table that shows which rows are linking back to it.

  • Can I set up a relationship after the tables already have data?

    Yes. Adding a Lookup column works on existing tables with data already filled in; you'll just need to manually assign the correct match for each existing row.

Related guides

Continue with more step-by-step guides for getting work done.

Create interactive demos like this one — free, no coding required.

Start for free →