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
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.
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.
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
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
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?
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?
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.