I work across multiple projects. I want to be able to have separate tables to track work for individual projects, then bring any rows with a due date of today (or check box of same) into a separate table to view them together so as to focus my daily work. I’ve been through a bunch of tutorials and h…

@Jean_Marc_Dieu @Janwyn_Toy I just launched a new pack yesterday called Cross-Doc Magic. It allows you to access table data from other docs with the NEED for syncing. I wrote it to specifically address this issue of the overhead of managing cross-doc syncs across many documents . . . Challenge: …

@Jeremy_Kriegel You can do this sort of thing using Views. Study the filters on the top 3 View tables in this doc. Maybe something like this can keep you moving forward.

Thanks for the reply. I don’t think I explained myself very well. If I have 3 separate tables, projects 1, 2, & 3, I want to pull some rows from each of those tables into a new table. Not filter rows from a massive table into separate tables. Thanks.

@Jeremy_Kriegel You can probably use buttons or automations to do something like that. NOTE: In that Views setup, you can hide the master table (for example, put it on a different section) and interact exclusively with the Views on an individual basis. You may have privacy reasons or similar that …

That’s exactly what I did. I created one massive table and then a bunch of views. I’m a bit concerned for performance as it grows, but hopefully will not be an issue. Thanks again for your input.

That looks great! I need to parse your code a bit as it is more complex than what I’ve done so far, but THANK YOU for setting this up!

@Jeremy_Kriegel I would like to understand your scenario better. Usually we recommend creating views and filtering them to show contents esp. as you are copying data between two tables - that seem to suggests both tables have identical schema. if you really want to copy records, here is what I woul…

Thanks for your reply @Krunal_Sheth . I didn’t want to copy data as then everything is disconnected. I think my mental model didn’t fit with how coda works. I wanted to have project level tables that I could pull out top tasks from into another table that would represent work for the day. I ended up…

@Dalmo_Mendonca I can’t access the logic/code you used. I’d love to learn how you did this as well. I have 2 tables that sync over from outside sources and need to be able to combine them in one. Thanks so much!

Combine rows from multiple tables into a single table?

Dalmo_Mendonca March 7, 2019, 3:42am 6

This is really stretching it, but take a look:

Tablefield as Controller field for formular

Topic		Replies	Views
How to combine multiple Tables together into a single big table	6	1982	March 21, 2023
"All my tasks" view -- only possible with a "one big table" of tasks across all projects?	8	881	June 23, 2024
Cross-Doc Into Single Table?	14	3289	April 28, 2022
Merge tables from different projects?	3	530	August 8, 2023
Merge Two or More Tables into One	4	334	March 2, 2026

Combine rows from multiple tables into a single table?

Related topics