Archive Stale Records
A 2-step recipe with Airtable. We can help you get access.
Recipe · 2 steps
Archive Stale Records
with Airtable
Locate a stale record via a formula and delete it.
- Search the table for records matching the staleness formula, returning at most one match to delete.
- Delete the matched stale record by its id. The record is permanently removed and cannot be recovered through the API.
What you'll need to have ready
- baseId: The Airtable base identifier (e.g. appXXXXXXXXXXXXXX).
- tableIdOrName: The table id or name to scan for stale records.
- staleFormula: An Airtable formula identifying stale records (e.g. IS_BEFORE({LastActive}, DATEADD(TODAY(), -90, 'days')) ).
For your developer
Arazzo workflow airtable:archive-stale-records, 2 operations: listRecords → deleteRecord. Specs on APIs.io.