"Ux groupe by" can't select twice same column?

ns_soft_studio1 · 08-06-2019 05:16 AM

Hi i need to ask why are we no longer allowed to select in “group by” same column twice?
It was of great help when you need to narrow down views by category.

MultiTech

I noticed that the other day too, still haven’t heard from the team about it.

Steve

How can something be grouped by a column twice?

MultiTech

It would give you a drill down, same functionality from the table view

Steve

But drill down into a column you’ve already drilled into? What effect would that have?

MultiTech

ns_soft_studio1

Hi Steve, it was a great help when you need to narrow down large table, it groups twice the same column and then you can see into one group at the time.

Lynn

Grouping by the same column twice is a common use. I hope it hasnt been discontinued.

ns_soft_studio1

Yes it has

Lynn

Does anyone from Appsheet know if this is permanent?

MultiTech

@praveen Just wondering if this is on the radar?

pravse

It’s always been the “recommended” approach for this to group first by the column and then by _RowNumber. This gives you the desired behavior, I think.

We hadn’t realized anyone was grouping by the same column twice! It doesn’t seem very meaningful.

Lynn

I thought everybody grouped by the same column twice . It shortens your list and is very handy. @MultiTech_Visions @Aleksi

pravse

I’m missing something that all my customers know!! :]
Could one of you show me a screenshot of what you get by grouping on the same column twice? And then show me a screenshot of the same table grouped by the column and then by _RowNumber.

That would help me understand what is missing. Thanks

Lynn

Sure , I made a new view as I didnt want to loose my double grouping .

If you add the row number you do get the double grouping thing , but I have never done it that way before.

MultiTech

Grouping by RowNumber after the original grouping column does work, I found one difference.

So here’s the view with grouping by client twice

When you tap on an option, you get the group name at the top:

Here’s the view grouped with the RowNumber

And when you tap on an option, the grouping IS NOT shown, but the list is:

I was actually completely unaware that using RowNumber was the “recommended” way of doing this; years ago when this grouping functionality was first established, this is how we always did it.

I guess it’s a matter of preference whether or not showing the grouping on the second page of the drilldown is a helpful/good thing; but ultimately the functionality of the drilldown remains the same.

Josh_Klassen

Hi
What program are you using to note your images? The arrows, text box’s, etc?

Thanks,

Josh

MultiTech

This service/program is amazing; super easy to use and get really nice results.

Josh_Klassen

Thanks @MultiTech_Visions

pravse

ok, let’s assume then that we are all set by using _RowNumber instead of repeating the column.

Both approaches are arcane, I admit.

I am somewhat amazed I had never seen the double column grouping before despite the thousands of apps I have looked at/debugged/etc. Or maybe I have seen it, but am just getting old :]

Aleksi

@praveen I have used it a lot

Peter_Bernsen

Me to! clients are very happy with it.

MultiTech

I noticed one difference: when you select the All option, they are no longer grouped and instead simply listed out.

Here’s what you get with double grouping (left over from an earlier app where I have this already implemented):

Here’s what you get when using the rownumber method:

Lynn

@praveen A lot of the sample Apps have double grouping of the same column. It could be confusing for new users to not be able to do this when they make their own apps?

ns_soft_studio1

HI again, I have to ask will it be enabled to group same column twice?
Because it is not the same when you do it like @praveen explained…