Looks great
@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.
@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.
Thanks for your help on this here:
Canât you group alphabetically by the category that your grouping by?
Looks good!
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
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.
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.
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.
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?
Always âŚ
Every single time!!!