How to display rows from 2 different tables in one table?

I have two tables: Projects and Tasks. Each of these two table have a lookup column with values from table Tags.

I’d like to make a table that will display all the rows from Projects and Tasks tables so I can group them by Tags column and by Type (Project or Task).

Is that possible?

You cannot combine different tables in Coda because it’s fundamentally wrong. Even if columns are the same, two separate tables are two entirely different concepts, according to the principles of database design.

What you can do:

  1. Look up all projects and all tasks for a tag into a Tags table. Then build a Details view on top of this: tags as navigation groups on the left, tasks and projects subtables on the right (in the layout itself).

  2. If projects and tasks are essentially the same thing in your system (i.e. a Project is just a task that has subtasks), then make it a unified table of both projects and tasks and build a grouped view on top of that.

1 Like