I’m an experienced developer with years of experience using SQL and relational databases. I’m having trouble figuring out how to do things in Airtable without something like SQL queries.
Specifically, right now I would like to delete a number of records, based on a query. In SQL this would look something like this:
DELETE FROM table_name WHERE condition ;
In this case, I would like the WHERE condition to be an aggregate, so that I can group by two fields, and then delete all but the record with the minimum value in another field.
Is there any way to do this in Airtable? So far the only way I can think of would be to export the data, load it into a DBMS, perform the modification, then import it back into Airtable. I really hope that’s not my only option.