
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 08, 2022 02:28 AM
is there a way to copy records between tables in different bases
or how to switch the current base
a little example would be helpful
thx
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 10, 2022 04:49 AM - edited ‎Nov 09, 2023 03:39 AM
Automations don’t work across bases, You would either need to write a custom script, or use an external low-code automation tool like Make,
There is a small learning curve with Make, which is why I created this basic navigation video to help. In that thread, I also provide the links to a few other Make training resources there as well.
If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consultant — ScottWorld
By the way, you didn’t explain what you are trying to do — do you really need separate bases to accomplish your goals?
In Airtable, it’s typically best to keep everything in one base, and use multiple tables and multiple views instead. I discuss tables and views in my free Airtable training course, which you can take for free by signing up for a trial membership with LinkedIn Learning: https://www.linkedin.com/learning/learning-airtable/

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 08, 2022 05:47 AM
What specifically are you trying to accomplish?
You could use Airtable’s sync for a one-way, read-only sync from source to destination.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 10, 2022 04:39 AM
I need an automation on submit copy the current record to another table in different base

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 10, 2022 04:49 AM - edited ‎Nov 09, 2023 03:39 AM
Automations don’t work across bases, You would either need to write a custom script, or use an external low-code automation tool like Make,
There is a small learning curve with Make, which is why I created this basic navigation video to help. In that thread, I also provide the links to a few other Make training resources there as well.
If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consultant — ScottWorld
By the way, you didn’t explain what you are trying to do — do you really need separate bases to accomplish your goals?
In Airtable, it’s typically best to keep everything in one base, and use multiple tables and multiple views instead. I discuss tables and views in my free Airtable training course, which you can take for free by signing up for a trial membership with LinkedIn Learning: https://www.linkedin.com/learning/learning-airtable/

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 10, 2022 04:59 AM
separate bases are not needed it’s just the way it is right now
and I needed a confirmation that this is not working as suggested
the idea was to have a separate base that contains all web form
which now turns out as bad practice :winking_face:
thx
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 09, 2023 03:08 AM
I need assistance in similar regard.
I have a base having details of my male friends, which includes their contact numbers, birthdates, marriage dates, their photo (mugshot), emails etc.
Another base similarly has the details of their spouses.
On a daily basis I get to see the birthday and anniversary in each base, separately, as a 'Daily View'.
Now, I wish to combine these two bases, so that in just report daily I can see the birthday and anniversary of all affected on that day.
How can I merge these two bases, or copy all records from one to the other? Also, before doing that would I need to ensure that the fields are common in both the bases? And, will the photos in each record also get copied?
Please guide. I will be grateful.
