I have an airtable base that is approaching the record number limit.
The main driver of this growth is a table full of inbound emails that my service categorises, processes, extracts data from and generally munges.
I only need to retain some of these emails, not all of them, and it will be fairly straightforward to write a filter to identify the keepers.
Is there a best practice method to select the candidate records, back up the data, then delete those rows?
I don’t think I’m looking for a normal backup solution for the entire base - at least that is a separate issue for me. What I want is a way to trim down my base by removing superfluous records, but keep the data from those records in case I need to access it in future.