How to combine tasks from two tables?

1

I have a master tasks table for all the tasks in our team, and a view on that table to filter by User(), so to show only the tasks belonging to the current user. Now we also want to sync our GitHub issues into that table or better user’s view.

So my idea was to sync the GitHub issues into a new Coda table, then create a mapping table with Coda users to GitHub user names, and to add a new column to the synced GitHub table using this mapping to show the Coda user each GitHub issue blongs to.

Last but not least I wanted to extend the view on the tasks table to also include those GitHub issues fromt he synced table that also belong to the current Coda user. However, as I understand a view cannot include data from multiple tables in Coda. So what is the best practice in this case - do we have to copy the rows from the synced GitHub table into the tasks table? But following the “single source of truth” principle I’d rather not copy rows from one Coda table into another.

On top of that, what if I want to combine the issues from multiple GitHub repos and the master tasks table in Coda?

What do you suggest?

2

Hello @maflobra

If I understand correctly, you want to add the issues as tasks, essentially adding them as new rows in the task table. In this case, to avoid duplication, I would recommend using the Merge Pack or the Formula Table Pack.

I believe both options are read-only, so any modifications would need to be made in the original table or view. Both options allow you to combine multiple tables or views into one.

Best Regards,
Arnhold