Generally speaking, deleting records from Airtable automatically is not recommended. Instead, we suggest you archive records instead using a checkbox or single select field and then filter out those archived records from your views. This way, data can still be restored in the future.
If your use case requires automatic deletion of records, you can use our Auto delete Records on Airtable automation. This automation can delete records using Airtable views, and/or custom conditions.
Automatic deletion is always risky, so please test this on a copy of your table first, and make sure to set the filter correctly to avoid deleting anything you meant to keep!
How to set this up
Create the automation from the Create Extension page in the correct base.
Select the correct table. This can be changed later so please confirm with a copy of your table first!
Under the Run tab, set the view for filtering. The automation will delete all records from this view, so make sure to set the appropriate filters in the Airtable view to identify records that need to be deleted. If no filters are set, the automation will delete ALL records from the table.
You can now run this automation manually, or have it run automatically.