Hi everyone, me again…
How would I go about grouping my headings in month order without starting on April.
I have a Month No. Column that I linked to the heading that produces the below.
This gives me my order, but I don’t particularly want the month number displaying. I’ve found various other topics on this but I’m struggling to get this to work personally.
I’m sure this is a quick fix for one of you experts.
Many thanks,
Matt
So you want “April 2024” instead of “4 April 2024”? Isn’t it just a matter of using the “Table Heading” column as the first screenshot, and then sort the data by the booking time? Is your “Booking” column a date/time column or not?
Hi @ThinhDinh, thank you for your fast reply.
So yes, I have I think replicated your comment in the first screenshot with the sorting being set by Booking which is a Date and Time column that is sorting the sessions perfectly in that booking order within each heading. The problem seems to be that the grouping by Table Heading is taking priority and ordering by alphabetical months - starting with April and not January.
@mcjmccartney - we are in the same boat!
Glide is a bit limiting in terms of grouping / sorting (Grouping was only added to the new tables a few weeks ago, so hopefully more options to come)
But If you group by a date field (in your first example, it looks like you have concatenated some text onto the end of the date (£395) which would make a text string, as opposed to a date) - it should sort chronologically. It certainly does for me - see screenshot.
If I am right, you may have to sacrifice the appended text at the end of the field you are grouping by.
Hope this helps!
Andrew
Ah this makes sense, thank you @Andrew_Davies
I hadn’t realised how soon this was released to Group tables like this - let’s hope those future options do become a thing. Thank you again.
@NoCodeAndy Is this an oversight in the new table component? I thought the data sorting should be put first, before the grouping. Say I use the same setup in Card & List, they prioritize the sort field, but not in the new table.
I have just tested to see if I change my component to a List and I can confirm it works as I like - but I’d ideally like to make this a Table and order this way as I’m sure others do!
It does seem as @ThinhDinh says, sorting takes the priority in the List component and does not seem to in the Table component.
