Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Airtable Record Cleanup: The One Script Every Base Needs

644 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Rupert_Hoffsch1
10 - Mercury
10 - Mercury

Hi everyone, just wanted to leave my newest video here about the one script that I'm using in all of my Airtable bases: A script to clean up records!

Let me know what you think and if it brought value to you 🙂 I'm posting multiple times per week, so subscribe if relevant for you.

 

 

2 Replies 2
Alexey_Gusev
12 - Earth
12 - Earth

 

Hi,
'oneliner' can be used. 😀

for (let tab of base.tables) await tab.selectRecordsAsync({fields:[]}).then(q=>q.records.filter(r=>r.name=='Unnamed record')).then(f=>{while(f.length) tab.deleteRecordsAsync(f.splice(0,50))})

Of course, I wouldn't use such script, because some of my tables contain necessary data in 'unnamed' records. So, at least exclusion list must be applied. 

In general, I think, such videos are useful to learn scripting basics.

 

💪👌love one liners! I think for learning though (aim of my content), this usually looks too cryptic for people / would've at least been too much for me when I started out