Airtable Feature Which Tells you Which Fields to Delete

Hi,

I can share my script, written for that purpose.

 

// galex 2024  FieldList.
const inv=base.getTable(base.tables.map(t=>t.name.toString()).includes('FieldList')? 'FieldList'
: await base.createTableAsync('FieldList',[
    {'name':'Name','type':'singleLineText'},
    {'name':'Type','type':'singleLineText'},
    {'name':'Unique','type':'number', options:{precision:0}},
    {'name':'Filled','type':'number', options:{precision:0}},
    {'name':'Example_5','type':'multilineText'}]))
const table=await input.tableAsync('Select table to process fields')
const flds=table.fields.map(f=>f.name.toString())
const query=await table.selectRecordsAsync({fields:flds})
const filled=fld=>query.records.map(r=>r.getCellValueAsString(fld)).filter(Boolean)
const sample=f=>filled(f).slice(0,5).join('; ')
const uniq=fld=>[...new Set(filled(fld))]
const fdata=f=>({'Name':f,'Unique':uniq(f).length,'Filled':filled(f).length,'Example_5':sample(f),'Type':table.getField(f).type})
const total=flds.map(f=>({fields:fdata(f)}))
const getlist=await inv.selectRecordsAsync({fields:[]}).then(q=>[...q.recordIds])
while(getlist.length) await inv.deleteRecordsAsync(getlist.splice(0,50))
while(total.length) await inv.createRecordsAsync(total.splice(0,50))
console.log('Done')

Hey ​@JeremyK,

Not exactly all features you are looking for, but I think you’ll find “manage fields interesting”. It does provide some of such insights. 

 

 

Also, recently somone shared here a custom tool really similar to what you are looking for. I’ll make sure to look that up for you and share it here as well.

For last you might want to submit this as a feature request using this form.

 

Completely different matter, but would love to have you join the March 2026 AT Community led Hackathon! Make sure to sign up!!

Mike, Consultant @ Automatic Nation 
YouTube Channel 

It creates a table with data useful to clean big tables. Like “Manage fields” but with additional important data and better abilities to filter/sort/group etc. Of course it would be better to have this in native Airtable feature.