Help

Grouping same names will leave out records

Topic Labels: Base design
Solved
Jump to Solution
1019 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Eliza_Piotrowsk
4 - Data Explorer
4 - Data Explorer

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
ScottWorld
18 - Pluto
18 - Pluto

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
ScottWorld
18 - Pluto
18 - Pluto

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: