Column Groups Actions: Rename, Coalesce, Duplicate, etc

Column groupings are great in the layout editor because they coalesce all the grouped data into one drop-down to vastly simplify finding data in complex tables/relations.

In the Glide Data Editor they are not as helpful and I see one Feature Request (Move entire column groups in data editor)

To be useful where they are most needed (maintaining complex data elements and structures) please consider these functions (selected via a right click on the header title):

  1. Coalesce all headers together. This is done in layout but not in the data editor. When adding an item to an existing grouping - the option should be there to coalesce it into its sibling grouping. If there are multiple similar named groupings - either automatically assign it to a grouping or let the user select (coalesce left or coalesce right). Currently I do a lot of dragging which is slow in tables with lots of columns.
  2. Duplicate a grouped set of columns and rename with a different header. This is super important now that Glide has actual reporting where you set up one set of reports and want to duplicate them for another (typically a different reporting period). In my case I want to duplicate Q1 reports into a Q2 reports and I have to individually duplicate/rename/change. Sadly error prone and just slow.
  3. And of course - move the entire group as noted above. Excellent case for good code/app/data housekeeping and app management!

Forgot the last but probably easily most doable and very dev-friendly:

  1. Rename a group heading!

Having to change the name of every individual constituent of a grouping to the new named group is tedious and error prone.

1 Like

Are you aware of the trick you can use to quickly move columns? (rename->filter->drag)

Uhm…no!!!

Will try now since I am renaming lots of headers/groupings.

But that reminds me of an ‘issue’ I have with filtering. When I use filter column and find the column I am looking for I: select the column and then get rid of the filter. I, would expect, that the selected column would be the one I filtered and then selected which would give me the context of where it is in the data layout (especially when I have 100+ columns).

But it doesn’t. Glide defaults back to whatever random column I had selected before I did the filter. I shouldn’t lose the filter context when the filter is removed (selected column and area within the table I was looking at).

Not sure if there is another trick for this use case.

To use the trick you might have to rename all the columns you want to group together… it could be simply putting the letter “A” in front of all the column names you want to move… then search for “A” and then move them around.

It would be nice if the highlighted column would stick regardless of filter view. It’s been brought up to the team before.

Thanks for the update - should I put in a feature request just for good measure? I didn’t see it but I was only looking for ‘grouping’ requests.

Regards - Matt

Putting up a feature request is good practice because the team does look at those. For this specific case I know it’s been discussed…but if you make a request I’d vote for it :saluting_face:

Ohhh this thread is a feature request… voted!

Hi there - how can we rename column groupings? Or is this a feature request? Thanks!

If you want to rename the name of the group, you would have to rename all of the columns individually.

I see! Thank you!

I have made the changes to my column grouping name, but I am not seeing the changes reflected in the Layout of my Glide app. Do you know why this could be? I’ve also changed the “Label” for the Page’s General and Options settings.

Do you have a screenshot? What do you expect to see? If you change the name of a column the only thing that would change would be the name of that column in the data editor and searches.

Column grouping does not affect the user interface (design) of the app.

Grouping columns in the Data Editor is visible and useful in two places in the app builder:

  • In the Data Editor: columns are grouped, and by clicking on the group header you can collapse the columns together in an accordion so they take up less space on your screen. The purpose of column grouping in the Data Editor is to organize the columns and aesthetics.

  • In the Layout Editor in the configuration panel on the right hand side: when pointing a component to a column, grouped columns will appear grouped in what appears to be a folder. This is practical to locate a column quickly, especially if the table contains dozens or hundreds of columns. When you change column groupings, you do not see the changes reflected in the configuration panel?

Is this related to column grouping? Would you mind sharing a screenshot of what you mean and the issue.

3 Likes

Thank you! That is very helpful to understand. I found the fix to changing the label in the layout too, I was changing the label in the navigation instead of the collection. All fixed! Thanks everyone for your help :slight_smile:

1 Like

Bumping this request. We need:

  • Bulk rename of group
  • Coalesce group
  • Duplicate Group

Vote people!

1 Like