Grouped by more than 3 fields

[Todd_Letourneau]

Is this something that is possible? I’m feeling limited by only being able to group by 3 criteria.

[Dan_Mitchell]

Todd_Letourneau:

ble? I’m feeling limited by only being able to gro

Is it still limited to 3 group choices? Is there a workaround?

[Matthew_Oates]

I agree…why only 3 fields? I actually need to group down to 4 levels. Is there a way to do this?

[JonathanBowen]

If this is your table:

And you want to group by Colour/Shape/Size/Weight, you could add a formula field that combines two of the four attributes, e.g. Colour/Shape:

Then created a grouped view which groups by:
- Colour/Shape
- Size
- Weight

If you do this, you’ll see a warning in the grouping config:

Obviously, you won’t be able to disassociate Colour and Shape grouping in this view on the fly, but if you want this just create another view where it is grouped by Shape/Size/Weight (for example).

Not perfect, but maybe useful as a workaround

JB

[Matthew_Oates]

I appreciate the thoughtful reply. I was more wondering this from a developer / design perspective though. Why would Airtable build this with a limitation of 3 fields for grouping? Why have any limitation at all? And, no, pivot tables are not a viable alternative for what we’re doing.

Does it cause more overhead on the servers when you have more then 3 levels of grouping? Is there some bandwidth limitation? Just curious why they would pick this arbitrary number.

[Alex_Yershov]

When adding records, I am finding that the number of groupings typically needs to equal to the number of filters so that records don’t “disappear” from a view (when all fields don’t match the criteria of the filter). When the groupings match the filter, the record is added seamlessly without and disruption.

I’d also love to be able to group by more than 3 one day.

@Katherine_Duh is it proper practice to tag you or someone from Airtable with suggestions like this? Or do you have a team that monitors discussions for suggestions?

Thank you!

[Andrew_Leker]

I also would like to advocate for more than group by max of 3. I can’t use the computed field method for the reasons listed above. In computer science, the special numbers are 0, 1, and 2. At 3 and above it’s generally all the same in terms of the logic (though UI could add challenge).

This limit really does hamper legitimate uses of the product and cannot be rationally explained to my stakeholders. This is a common use-case for your users who want to use AirTable, but who may start looking elsewhere because it seems like a “silly” constraint. As a software developer, I’m sure my systems have lots of silly constraints as well, but when customers identify pain points, they get fixed. I hope you’ll do the same, knowing full well that you’ve had an aggressive road-map for quite some time and that your users admire your tenacity.

So, in spite of the strong advocacy of this position, well done and keep it going!
Andrew

[Jessica_Pena]

I just abruptly learned that there is a limit of 3 for groups… +1 from me to increase the max.

[Dragana_Knezevi]

I’m adding my vote here to improve this feature and have more than 3 fields to group. Thank you in advance!

[ilia_laliashvil]

Really need +1 Group here too.