Apr 07, 2021 07:21 PM
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.
Apr 07, 2021 08:41 PM
More about the Scripting app can be seen here:
Apr 07, 2021 08:56 PM
Thanks for the prompt reply, I’ll give that a look.
Apr 07, 2021 09:06 PM
Can you direct me to some sample scripts that might get me close to the type of thing I’m wanting to do? Thanks.
Apr 07, 2021 09:10 PM
I should have read the link you gave me first. I see there are plenty of pre-built scripts.