Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Empty record showing up when grouping by single select field?

Topic Labels: Views
Solved
Jump to Solution
882 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

image

1 Solution

Accepted Solutions

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.

image

See Solution in Thread

4 Replies 4

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.

@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.

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.

image