🆕 Grouping

General
22

After grouping by and limiting to x items, after pressing the “see all” , the format is not kept .
So I have cards and after “see all” a list appears.
It should keep cards as first items shown.

23

Isnt it easier to classify it ‘unassigned’ or something else yourself?

24

Sure. Could do that, but feels wrong that some items are missing. This is not a filter after all?

25

Well, if you can solve a problem yourself, why not :wink:

1 Like
26

Is there a way to sort the grouping labels? I created Group A and Group B, but group B shows up above group A, which isn’t helpful. My groups need to be sorted in alphabetical order, or by an order I determine.

1 Like
27

Hi @Jeremy_P I agree there is a small niggle here. To sort the group headings you need to sort the list but that field, but then of course the contents of each group may not be sorted the way that you want. But, if you sort the list the way that you want, then the headings will be sorted based on the list sort if that makes sense. I think that the Glide Team need to make a little tweak to the functionality to address this. Additionally, as noted previously, beware of missing entries if they don’t fall into any of your group categories - they simply won’t show up as there is no “unassigned pot”.

2 Likes
28

You could probably create a template column with the grouping column and the column you really want to sort by, joined together. Set your grouping column for the groups and the template column for the sort.

3 Likes
29

That’s an interesting approach. May just try that one. Probably a template named “SortKey” or something similar.

1 Like
30

I just realized today that Grouping can make a really nice Calendar list replacement with a lot more customization. Haven’t done it yet, but thought I’d share.

5 Likes
31

Great idea :bulb: thanks

1 Like
32

Thanks for raising this question. I would like to know how the groups are being sorted as well so that I can customize the order of the grouping. It’d be great if Grouping had it’s own Sorting component option!

1 Like
33

@Ed_Chao - Good question! I think that the list is sorted based on the standard list sort and then whatever group the first item belongs in appears at the top, but I can’t be 100% certain.

34

@Jeff_Hager I’ve been doing this a lot and my users love it:

image
image373×608 46.9 KB

5 Likes
35

Looks great :+1:

36

@Rosewebstudio. Thanks. Only issue I’ve found is that you need to create the Date column in the Google sheet rather than the Glide Data Editor in order for it to format correctly.

My dates usually come from a form submission where I use a “special column” to capture the timestamps of the submission. I then want to group them in the UI.

I have also grouped successfully using “today”,“yesterday”,“previous 7 days”, “previous 30 days” and “older”. For this I use the Google sheet again with its ability to calculate days between “now” and the submission timestamp. My users love this too.

2 Likes
37

Good to note, thanks

1 Like
38

I started playing with this a little bit yesterday. I didn’t need to do a formula in the sheet to format the date. Instead I just set the formatting in the date column and created a template column to “lock in” the date that was formatted within Glide. The template is what I use for grouping. I think the underlying issue is that the grouping will still actually use the underlying timestamp value, so if the days match, but the times don’t exactly match, then they are grouped separately. I did however still need a formula in the sheet to duplicate the date column, so I could have a separate column that I can format in Glide to only displays the time.

Here’s what I have for a quick test so far.

Screenshot_20200815-115114
Screenshot_20200815-1151141080×2300 178 KB

6 Likes
39

@Ed_Chao I agree with @V88 that the groups appear in the order that your sheet is sorted.

As I mentioned in this post, if you need to sort the group, as well as another column value, then you could create a template with both values. Use the template for sorting and the group column for grouping.

This isn’t necessary for you, but for me I need the groups in a specific order that’s not alphabetical. I have another sheet that contains the groups and their order number. I use relations and lookups to get the sort order number and I use that to build my sort order template column. It’s still grouped by the text, but the whole sheet is sorted by the template column, which contains numbers.

3 Likes
40

Thanks for your help on this here:

1 Like
41

Can’t you group alphabetically by the category that your grouping by?