Hey there !
I would like to bulk delete records that match a certain criteria in the app Front.
I will link Front and Airtable via webhook but I wonder how to write a script to delete only the right records.
Thank you !
Hey there !
p.s. As a top Airtable consultant, I can help you set this up. If your company has a budget to hire an Airtable consultant, please free to contact me through my website: Airtable consulting — ScottWorld
Hi Julie, this thread contains a script that will delete all records in a specific view, which should be all you need I think.
You’ll need to make some minor adjustments to make it work within an automation though, let me know if you need help with that
Welcome to the AIrtable community!
What will be sending the webhook? How will that webhook be triggered? What information will it have to uniquely identify the records?
Does your app need to search Front to see if the records meet the criteria? Or will Front know which records need deleting, and Front will send the webhook?
The reason that I haven’t learned Make is that I personally think it’s much easier & simpler to use an automation tool that is native to Airtable and doesn’t require and additional subscription or a new (visual) programming language.
I’m glad we’re friends, despite all our differences. Make doesn’t require writing scripts, but it does require understanding how to think logically, which is most of what programming is. The rest of scripting is grammar and spelling.
Nor should they need to learn it, in my opinion, For example, why would a veterinarian who is setting up Airtable to keep track of his pets want to spend weeks or months learning a computer programming language so that he can create one simple automation in Airtable? It’s a huge waste of his time and energy and money. He has a practice to run.
Calling Make a programming language makes it sound more complex than it really is. While it can definitely get complicated, for most people’s needs it is as easy as snapping together legos. Anybody can look at a colorful ball that says “create new Airtable record” and know immediately what it means. Make is mostly point-and-click (and in plain English).
You left out vocabulary words, which is the big one. Scripting is an entirely different language, like learning Greek or Hungarian. Some people want to learn foreign languages. The majority of people don’t need to. People specifically come to Airtable for its ease of use… and snapping 2 colored balls together in Make carries on that ease of use.
But the great news is that there is something for everyone! For computer programmers like you, there’s scripting! And for computer programmers like me, there’s Make!
The irony here is that we’re both computer programmers, but after 30+ years of writing code, I’m on a much-needed break from writing code for now!
Hey ! Thank you for getting back to me ! The mailing application Front will be sending the webhook and will be triggered by an email with a specific tag. It will have a set of email adresses, and names to identify the records.
And I have a little experience with Java Script !
You can learn more out Airtable receiving webhooks in this support article. Note that the data must be sent via “post” not “get”. Do you know if Front is capable of generating a “post” request without using a third party service? (I’m curious about Front and would appreciate it if you share any info on the Front side if this integration.)
Your script will need to get all the records from the table using selectRecordsAsync.
Finally, you will need to use deleteRecordsAsync to delete the records.
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.