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?