Hello! I have been organizing the content of my company’s information for a few weeks and got to the point where I could set up a customer table from my list. When I choose what information is going to be present, and then group the information, even though the essential groupings are identical, Airtable is breaking the information up. You can see the attached screenshot (with names redacted) for an example.
Customer Relationship and Market Sector are the items that I am grouping by and this is what happens:
It’s because you have extra spaces in some of your fields, but ridiculously, Airtable hides all extra spaces from being shown onscreen. So you either have trailing spaces or leading spaces or multiple spaces between your words.
Welcome to the crazy upside-down world of Airtable where nothing makes sense & everything is half-baked.
To sum up the craziness here: Airtable won’t SHOW YOU your extra spaces, but Airtable will still SORT/GROUP/FILTER/SEARCH/etc. as if your extra spaces are actually there. So you can’t visually tell what’s really going on.
You’ll have to manually double-click into your fields to see where the extra spaces are so you can clean them up, but as soon as you click out of your fields, the spaces will visually disappear again.
And the most important thing you can do is email Airtable’s support team at email@example.com to try to get them to fix this behavior… maybe you’ll have better luck than the rest of us have had for the last several years.
Question: If the field settings you screenshotted directly above are Single/Multi Select Fields, why are they shown as plain text in your first screenshot? Are you actually grouping by Lookup or Rollup fields?