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

Grouping same names will leave out records

Topic Labels: Base design
Solved
Jump to Solution
577 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello, I am a new user- I created an Airtable base that is updated via Zapier from a Google sheet. The records seem to be populating from the Google sheet correctly, but when I try to Group by Client name, not all the records are grouped. I will have some records with the same name in it’s own group. This has happened a number of times so manually dragging those records to the other grouped records of the same Client name has become cumbersome.

Has anyone else experienced this and know of a fix or what I may possibly be doing wrong?

Thanks in advance for any help on this topic.

1 Solution

Accepted Solutions

Welcome to the community, @Eliza_Piotrowski!

I would check for extra spaces (or invisible characters) at the end of the client name, or the beginning of the client name, or somewhere within the client name.

See Solution in Thread

3 Replies 3

Welcome to the community, @Eliza_Piotrowski!

I would check for extra spaces (or invisible characters) at the end of the client name, or the beginning of the client name, or somewhere within the client name.

Thank you ScottWorld, that was it! I went back into the Google sheet I was pulling the data from, highlighted the column that contained the data, and used the Trim whitespace option in Data.

That’s great to hear! You’re welcome! :slightly_smiling_face: