Jul 31, 2022 03:18 PM
We use airtable for managing our contacts. So we were updating some of the names in our Airtable database. We tried to paste in the new title for one contact, and somehow it pasted that text into every single field in the entire database!
The undo function doesn’t work, and there are no “snapshots” of the dabs we can roll back to, even though they are supposed to be taken automatically form time to time. We can see in the expanded records that the history is still there, but we can’t find any way to restore the data…
Can anyone help?
Jul 31, 2022 04:58 PM
Welcome to the community, @Bianca!
Ack, I’m so sorry that this has happened to you! I’m not an Airtable employee — I’m just an Airtable user like you, and I run an Airtable consulting company. (The Airtable employees rarely visit these forums, so it’s just us users voluntarily helping out each other here.)
Just to make sure that this is not a temporary glitch on Airtable’s side, did you try logging out & logging back into your Airtable account? Did you try logging in from a different machine and/or web browser as well?
If you’ve already tried that and the same problem remains, I honestly don’t know if you’ll be able to get any of your data back, unless you’ve manually made a duplicate copy of your base recently that you can revert to.
You said that you’ve already tried undoing by pressing command-Z or control-Z, right? And you said that there are no snapshots at all?
If all of the above has failed, then you’ll need to send an email to email@example.com to see if they can do anything for you. Although I wouldn’t hold my breath (they know less about Airtable than us consultants in these forums), and it could also take several days for them to get back to you. It’s highly unlikely that they will be able to help, but it would be the only path to go down if the problem remains.
For what it’s worth, I have been personally complaining to Airtable for years now about their terrible backup/snapshot system. What kind of ridiculous backup system only takes snapshots “from time to time”? It should be done on a regular basis (i.e. daily or hourly)!
The way that Airtable’s ridiculous backup system works is that it silently counts the number of keystrokes that your team makes in your base (for example, 25,000 keystrokes made in the base), and when you’ve gone beyond that threshhold, then it finally makes a backup. It is ridiculous, frustrating, and unprofessional. But they steadfastly refuse to improve how this works.
Moving forward, you’ll need to manually stay on top of your own backups, because you can’t depend on Airtable to do it for you. Here are a few tips:
Aug 01, 2022 11:19 AM
Wow, I did not know that, thank you for letting me know. Is it keystrokes or database writes? If it is data writes could a script write and delete 25,000 records every 24 hours to force the snapshot?
Aug 01, 2022 12:09 PM
Not sure! It might be database writes.