Delete Records In Airtable Automation Without Zapier or Make

[@JustEedee]

Exactly what I needed! I used single select "DELETE" as my trigger and it worked like a charm. Thanks Ben!

[@BenGreenSystems]

Glad it helped! Woot woot!

[@fjodorallgaier2]

great! thanks. For Multiple Records and taking the Airtable limitation into account of deleting maximum 50 records: let table = base.getTable("Table Name"); let inputConfig = input.config(); let recordIds = inputConfig['recordIds'].slice(0, 50); await table.deleteRecordsAsync(recordIds); just run it multiple times

[@BenGreenSystems]

This is incredible! Thank you so much

[@ricardofahrig]

Very helpful, thanks!

[@polinanovikova2504]

Thank you Ben! It helps me a lot! Love your videos, they are beneficial 🙏

[@bradlegassick9327]

Ben yoy gotta get Nacho a bigger room! Thanks for all the awesome content. Keep it coming Cheers

[@BenGreenSystems]

Working on it haha. Thanks for the support

[@jeanninemcwhorter919]

Hey Ben! After following your videos I automated with slack and now have bases from slack on my workspace that I need to delete, how do I delete them?

[@GeographicusMaps-y3c]

I set this up, and it works, but it only deletes 1 record, despite multiple records matching criteria - which is if a certain field is empty. Is there any way to make it delete all matching records.

[@dmitriyprokhnevskiy1467]

hmm, I'm curious how it would work if instead of a checkbox, you want to delete the records that have a certain dropdown status selected.

[@bastienrch2451]

Exactly the same question, I tried it like this but couldn't figure a way to do it

[@BenGreenSystems]

There is another script to delete all records in a view. I will have to do another video

[@phillip6746]

@@BenGreenSystems I'm also interested in this video :)

[@eliresnik3531]

do you know if its possible to delete information in certain fields based on a check mark? Basically in Europe, we have a privacy clause where we cannot store people information when it is no longer necessary. I am trying to figure out a way, that when we check "Case has been resolved", the customers information/number/address is autodeleted. I would still like to keep the full record, just want to delete those certain fields based on a condition

[@BenGreenSystems]

Yes, you can do this with an update record automation. kzbin.info/www/bejne/nIvYl2Voor6VaKs

[@noellep5447]

Do you have an updated version of this script? I am trying it and getting errors in Airtable with the syntax. Guessing there have been some changes made to the scripting since you published this but my coding skills are not good enough to know how to edit.

[@hryhoriikrasko4114]

nope, worked for me today

[@JeffHladek]

This was so helpful!

[@keithwhitson]

Which tool do you use to record your videos?

[@지혜-m6b]

hello, thank you for this video. I error has occured. can you help me? the error reason is below. what should i do? TypeError: Invalid arguments passed to table.deleteRecordAsync(recordOrRecordId): • recordOrRecordId → recordOrRecordId should be a Record, not undefined or recordOrRecordId should be a string, not undefined

[@BenGreenSystems]

This seems to be a testing error - possibly your test record is null or undefined. Make sure your test is successful (green). If it is, then I would also consider what the record id string looks like that you are passing into the automation. Did you get it working?

[@JorgeGonzalez-ds9ht]

Thank you for this video. It works perfectly however I tried to setup the automation using a trigger for example I want the records to be cleared all of them every 15 days or every month and i tried both but it didnt work. Do you have some insight on how the script may work with time automations?

[@bladesNstuff]

I setup a view that only shows records that were created before two weeks ago. Then I set the automation to delete anything that is in that view. It’s nice became once you have a “delete view” any that gets filtered it to it gets deleted automatically. So you only need one delete automation per table.

[@BenGreenSystems]

What Lennon said should work. @Jorge Gonzalez did this work for you?

[@davnunn1]

Interesting, but I got an error in testing recordOrRecordId should be a string, not undefined

[@BenGreenSystems]

Your input needs to be filled in, not empty, not undefined. You may need to re-test your trigger.

[@CharlieMelendezNoCode]

Nice!

[@BenGreenSystems]

Thank you! Cheers!