Cross Populating Bases

[Ryan_Silverman]

I’m an Estate Manager and I have many properties owned by different people. I have them all as separate bases so owners can look and have them all in one workspace. I have todo lists in each one which is great but would like them all to populate in a separate base so I can see and supervise instead of having to go into each base. Ideally to make a shopping list too.

Can you help me? Thank you

[Justin_Barrett]

Welcome to the community, @Ryan_Silverman! :grinning_face_with_big_eyes: Have you looked into the sync feature?

Airtable Support

Airtable Sync - Basic setup

Using Airtable Sync, you can sync records from a source base to one or more destination bases.  To set up a sync, you need access to a shared view that is enabled for syncing. You can then use this...

You could sync the task tables from your various property bases into a single base. From there you could set up an automation that would copy everything into a single master table. With a bit more work, you could even design it so that if you mark a task as complete in the master table, it would send a webhook call to the proper source base, triggering a webhook-driven automation that would mark the original task as completed.