May 06, 2020 07:51 AM
Is there a way to restore a snapshot overwriting the current base? As opposed to creating a new one.
May 07, 2020 06:22 AM
I’ve been searching for a way to accomplish this for a while.
The only way I found would be exporrt/import a CSV file. Is there a more streamlined alternative?
May 07, 2020 06:26 AM
No, but why are you looking to do this? Overwriting the existing base is the same as deleting the old base & starting to use the new base instead.
Most people want to keep both bases after a restore, so they can compare the data between the two bases.
May 07, 2020 06:56 AM
Thanks @ScottWorld! Yes, that makes sense. But in my case I have a series of integrations and automations setup with my base. If I delete it I’ll have to update all the integrations with the new base.
May 07, 2020 08:15 AM
Ahhh, that makes sense!
Yeah, I can see how that would be a real pain to update all of your integrations, especially if they are complex or especially if you have a lot of integrations.
You may want to add this as a feature request in the Product Suggestions topic.
May 08, 2020 05:04 AM
I got in touch with their support an they recommended exporting and importing a CSV file.
My problem now is to import a CSV on a table containing linked records. The linked records don’t get imported.
May 08, 2020 05:33 AM
.Linked record fields will import just fine, and they will link to other tables just fine.
But you have to import each table separately.
And you will have to do either an “update import” or an “add import”, depending on which tables you’re importing in which order. That’s because when you import records into linked fields, Airtable will automatically create new linked records for those records in the linked tables. This is a fantastic behavior of Airtable, because it enables tables to automatically link to one another without manual intervention.
But in your case, you will need to update those records in those tables when you import, instead of adding new records when you import.