Sync multiple tables to one table?

How critical is it that each project is its own table? Could you not just have them all in one table and use one set of views to differentiate projects and another set of views to show one team member’s projects each?

Otherwise you could sync multiple tables into a single table, but that table would have to exist in another base.

Thanks for the reply.

Each project has around 300 tasks, and we have at least 10 projects running throughout the year. It is critical they each have their own table.

That’s fine to have a table outside the base if that was the only way - as long as the team member could see all tasks assigned to them from all tables. Multi-syncing could do that?

Welcome to the Airtable community!

Keep in mind that there is a maximum of three sync sources per table. If tasks for each of your 10 projects are in their own table, you will not be able to sync all 10 directly. There are workarounds that involve syncing in chains. However, I do not recommend that method as it is very difficult to maintain.

Also, you cannot edit the original tasks from the synced table. You can only edit the tasks from their original source table.

You know your base best, but having all tasks for all projects in one table does have some advantages. Personal views, view sections, filtered shared views, and rollups with record links all help.

Is there still a limit of 3 sources per table for multi source syncing? I haven't been able to find these details and am not on the Business plan to be able to test.