@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.
@Jeff_Hager I’ve been doing this a lot and my users love it:
@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.
Good to note, thanks
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.
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.
Thanks for your help on this here:
Can’t you group alphabetically by the category that your grouping by?
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!).
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
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 V
Group 2 V
(where clicking on “V” next to Group 1 would dropdown/expand and show A, B, C)
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.
Thanks for letting me know. I would be struggling to do that, so you saved me some time.
No problem - welcome to the community!
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.
How many times do guys you see a post in the Announcements category and get an endorphin rush before realizing that you are looking at a 6 month old thread?