Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Combine Table in Base with Table from Another Base

Topic Labels: Base design Formulas
341 2
cancel
Showing results for 
Search instead for 
Did you mean: 
cjones
4 - Data Explorer
4 - Data Explorer

Hi all,

I'm working on a project and I need to Combine Table A from Base 1 with Table B in Base 2 to create one table, Table C.

I've already linked the two original tables to be in the one base, but I can't figure out how I can automatically combine the two.

Thanks in advance!

2 Replies 2
Cobey-Wan
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello there. I believe I understand your issue but I need some clarification.

  • Where is "Table C"? - Is it in a 3rd base? Or does it live in "Base 2"
  • What subscription plan do you currently have? - Multi-source syncing is only available to Business/Enterprise customers

I have a feeling your subscription plan may be holding you back. Either way let me know and we can figure something out for you.

🤘Airtable Rocks 🤘

If you want data updates from Table A and Table B to flow into Table C continuously, I'm afraid you're going to need to use multi-source syncing, which requires a Business and above plan: https://support.airtable.com/docs/multi-source-syncing

How are Table A and Table B used?  f it's purely for data entry, you could create Interfaces that work off of Table C and give those to the users of Table A and Table B instead, which would let you have a consolidated view and also keep the data hidden from the users of Table A and B