Prevent creation of blank records in a table

[Julian_Kirkness]

Would it be possible to make it impossible to create blank records in Airtable - it’s so easy to create these that bases become littered with them. It’s even worse if you accidentally add a record in a grouped view because linked record are created which are otherwise blank.

One way to do this would be to give the user the option of making one or more fields ‘required’ - and without them the record would not submit.

I find having to constantly delete such empty records quite annoying!

[Alex_Proteau]

Yes, this is very annoying. My team and I are using it daily and I would say that this our biggest issue.

[Michael_Berman]

You could make a blank cell view that filters everything but blanks and just delete all the records in the view every once in a while…

[David_Torbett]

There are solutions for removal of them once they are created as per above suggestions, but we have a table with autonumber being used for sequencing and for audit purposes we prefer there to be no gaps in the sequence. This very issue causes the most reasons for gaps. The other reason is not being able to restrict some users from the ability to delete a record :frowning:

[Andrew_Enright]

We literally have a script that runs against such a view and flags blank records as “ghosts” :ghost:

It’s a dumb workaround that still requires human record deletion or repurposing of ghost records with “old” record IDs.

[Ultan_Costello]

Bump, Bump & Bump Again.

This is our single biggest frustration with Airtable - An otherwise brilliant product.
The option to only create a new row on “Double Click” would resolve this neatly.

[nnnnneil]

Bump bump bump too! You should be able to define views where new line records cannot be added in that view.

[Tyrone_Elliott]

Is there a solution for this yet? if not bump!

[Noam_Yorav-Raph]

+1. I’m using an Autonumber to create unique IDs for each record, and having it being incremented each time someone clicks the row by mistake is annoying.

[Kevin_Leahy]

Bump! I’m about to train my team and anticipate that the accidental creation of records will be our biggest issue. I’ve been using Airtable for a month and haven’t been able to avoid accidentally creating records every single time I use the (otherwise brilliant) interface.

[Maurice]

Yeah this owuld be nice to fix, annoying having to clean house all the time.