At our company, we have tables that can have up to 30-40 columns in them, especially on the “summary” or “master” tables, where data is assembled from other tables. This can get very confusing.
What If we could group similar columns together in a similar way we group rows? Color-coded, collapsible, and individually shareable. It could be quite powerful.
I like this idea as well, especially given that you can’t reference fields in joined tables without first making a lookup column in the current table first.
I’m in a similar situation with the electronic [aviation] logbook I’ve built for myself where it’s gotten quite wide, and I’d like to be able to hide the cruft in a single go.
But if there’s a need for multiple views with the same fields (such as different filter or group criteria) it’s back to the tediousness of individually hiding multiple fields.
If you’re making multiple views in which the same combinations of fields are hidden or you’re using the same groupings, I highly recommend making use of the copy view configuration feature to speed things up!
I would like to also vote for this feature. Having table with 50 columns. When editing a particular record (expand record), I’d like to see fields grouped. Otherwise it is an explosion of fields very inconvenient to maintain.
I do have separate views that act like groupings, but then I have to find the same records in all these separate views if I want to edit fields of particular groups: pretty complicated. I want to see all fields of a particular record on the same page grouped using tabs or kind of.
You could ask one of your data analysts to run a query finding all users who have at least one table with more than 20 columns. I am sure that all these customers would be happy to have column groupings. This would measure the value of this feature.
