Empty record showing up when grouping by single select field?

[Stan_Zukowski]

We have a base that lists all of our dealers’ contact information, including state.

State is a single-select field, with all states listed, just to make it easier for people to enter the correct state, and also to ensure consistency of the state abbreviations.

I created a grid view grouping our dealers by state, which worked fine. However, at the top of the list is an “empty” record – and I can’t figure out why.

I looked in the single select list (where you manually input the data) and didn’t see any blank or empty fields.

I also looked at all the individual dealer entries to make sure each one has a state selected, and they all do.

Any ideas why that empty field is appearing?

[David_Presley]

It could be there is an extra blank record in your base. If you stop the grouping and just look at your data in a grid view, then sort the “State” column by A-Z. The empty record should come straight to the top.

[ScottWorld]

@Stan_Zukowski If you ungroup and then regroup, is the empty group still there? You might need to reach out to support@airtable.com and let us know what they say.

[Databaser · Accepted solution]

Hi @Stan_Zukowski

When you “group” based on a select field, you get the option to “show groups with no records”. This lets you see the options from your select field that haven’t got any records yet. When you activate this option, it also lets you have an option to create a record under a new option in your select field.

You can (de)activitate that option via the “Grouped by x field” option.

[Stan_Zukowski]

That was it! Thank you!