Mar 25, 2022 03:21 PM
I need a feature where I can archive a particular record so that once that record is archived it cannot be changed in the future or be affected by some of my other formulas or automation. I want it to be “locked”.
Mar 25, 2022 08:00 PM
Could you create an automation to push that record to another service (Google Sheet) or another Airtable base entirely based off a checkbox criteria or select list perhaps?
Mar 26, 2022 12:13 PM
I mean yeah, but if I chose Airtable I would like to stick with it and not to have external sheets and documents if you get me.
Who knows, maybe I want to have some kind of statistics, and if data is changing non-stop, those information and let’s say numbers won’t be correct. Maybe the depend on USD to RSD value or something like that. You know…
Mar 27, 2022 09:09 AM
This is a useful business requirement but there are many more you should consider before asking for a specific recommendation. At the outset, no one should contemplate an archival strategy with Airtable without a firm understanding of scale - how many archive records are we anticipating? Another - what analytics are you anticipating for data “at rest”?
I would read this - specifically the latter part of the article which deals with a segmentation of operational vs historical data.