🆕 Grouping

Looks great :+1:

@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

Good to note, thanks

1 Like

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.

6 Likes

@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

Thanks for your help on this here:

1 Like

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

Using this now with the new Posts Layout (Cards minus image) and Join Text Column —beautiful:

11 Likes

Looks good!

1 Like

Yes @Mark, I may be wrong in my use of group by - filtering - choice component, but if not, there may have opportunities for improvement in in-line lists display for:

1/ “Choice component” & “Group by”: when a user records an item (via a form for ex.), for UX matters, we sometimes cannot impose her/him to fill-in all choice component criteria.
→ But when the in-line list of these items is displayed with a group-by view, we may still want this item to be displayed in a group-by category “Unassigned”

2/ “Choice component” & “In-line list Filtering”: sometimes we propose multiple choice components to users to ease the search of items; we therefore filter the inline list by all these possible choices. Again for UX matters, we may not impose to users to have all these choice components filled-in by the user.
→ But we may still need the in-line list displaying all items filtering by the choice component(s) which is/are filled-in by the user

These two topics would avoid us to build if-then-else & co as well as multiple in-line lists per type of filtering (and we may have a lot of them!).
Thanks

Current situation: given above constraints, we need to set-up 1 in-list per filter

Otherwise, if we customize all the filters in 1 single in-line list, if all the choice components are not selected by the user, the in-line list does not display anything

3 Likes

Hi @Jeff_Hager @ThinhDinh, in relation to the above post, do you have a “magic workaround” with all the common “barbarian tools” (relation, template, lookup & families) to create 1 inline list with multiple filters instead of 1 inline list per filter?
Thanks in advance

Is there a way to make Group headings into a list that serves as an expandable dropdown menu or link to the content it is grouping?

In other words:

Group 1
A
B
C
Group 2
C
D
E

Would become:

Group 1 V
Group 2 V

(where clicking on “V” next to Group 1 would dropdown/expand and show A, B, C)

-Or-

Make Group 1 and Group 2 text links that lead to another screen listing either A, B, C (for Group 1) or C, D, E (for Group 2)?

That is not possible, sadly. You cannot add components on a list screen.

1 Like

Thanks for letting me know. I would be struggling to do that, so you saved me some time. :grinning:

1 Like

No problem - welcome to the community!

2 Likes

This is tricky but possibly you can do this setup in a details view if you don’t have too many groups:

  • Have an action text that increments a user specific column. If increment column doesn’t equal 1, then increment by 1, else increment by -1. Use an If Then Else column for this.

  • If the increment column is 1 then show the inline list for that specific group.

  • Set the inline list to only show some items so when you have a large number it will have a See All option.

However this won’t scale well, as I said in the first paragraph. You need 2 columns for each group for the increment thing.

3 Likes

That’s good information and thank you. I was able to get close by creating a pivot table and using Features>Action>Link to Screen but that only provided the same exact secondary list regardless of what I clicked on in the first list. However, pivot tables for this purpose are awkward and won’t scale well either. Going to work through some things with Javascript first, but still trying to do as little as possible in Sheets other than formulas.

1 Like

How many times do guys you see a :new: post in the :orange_square: Announcements category and get an endorphin rush before realizing that you are looking at a 6 month old thread? :joy:

11 Likes

Always …

2 Likes

Every single time!!!

1 Like