Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Airtable Record Cleanup: The One Script Every Base Needs

1489 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
13 - Mars
13 - Mars

 

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.

 

Rupert_Hoffsch1
10 - Mercury
10 - Mercury

💪👌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