# Group my tables in month order without starting with April

**URL:** https://community.glideapps.com/t/group-my-tables-in-month-order-without-starting-with-april/74957
**Category:** Ask for Help
**Created:** [July 17, 2024, 9:10am UTC](https://community.glideapps.com/t/group-my-tables-in-month-order-without-starting-with-april/74957 "2024-07-17T09:10:49Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![mcjmccartney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjmccartney/32/70883_2.png) [@mcjmccartney](https://community.glideapps.com/u/mcjmccartney)
#### Post date: [July 17, 2024, 9:10am UTC](https://community.glideapps.com/t/group-my-tables-in-month-order-without-starting-with-april/74957/1 "2024-07-17T09:10:50Z")

</div>

Hi everyone, me again…

How would I go about grouping my headings in month order without starting on April.

 ![Screenshot 2024-07-17 at 10.00.04](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/d/fd476e39c273df94bd3d7336461749b3beaf3291.jpeg)

I have a Month No. Column that I linked to the heading that produces the below.

 ![Screenshot 2024-07-17 at 10.06.56](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/1544c43722e68a658805527a48edec810a3152dc.jpeg)

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

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 17, 2024, 9:51am UTC](https://community.glideapps.com/t/group-my-tables-in-month-order-without-starting-with-april/74957/2 "2024-07-17T09:51:28Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![mcjmccartney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjmccartney/32/70883_2.png) [@mcjmccartney](https://community.glideapps.com/u/mcjmccartney)
#### Post date: [July 17, 2024, 10:19am UTC](https://community.glideapps.com/t/group-my-tables-in-month-order-without-starting-with-april/74957/3 "2024-07-17T10:19:08Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)
#### Post date: [July 17, 2024, 11:38am UTC](https://community.glideapps.com/t/group-my-tables-in-month-order-without-starting-with-april/74957/4 "2024-07-17T11:38:41Z")

</div>

@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.

 ![Screenshot 2024-07-17 at 12.37.32](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ce79e742f7e9df8a3be61e0911aaffe0b13e01a0.png)

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

---

<div class="post-metadata">

### Author: ![mcjmccartney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjmccartney/32/70883_2.png) [@mcjmccartney](https://community.glideapps.com/u/mcjmccartney)
#### Post date: [July 17, 2024, 11:49am UTC](https://community.glideapps.com/t/group-my-tables-in-month-order-without-starting-with-april/74957/5 "2024-07-17T11:49:23Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 17, 2024, 1:07pm UTC](https://community.glideapps.com/t/group-my-tables-in-month-order-without-starting-with-april/74957/6 "2024-07-17T13:07:14Z")

</div>

@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.

---

<div class="post-metadata">

### Author: ![mcjmccartney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjmccartney/32/70883_2.png) [@mcjmccartney](https://community.glideapps.com/u/mcjmccartney)
#### Post date: [July 17, 2024, 1:20pm UTC](https://community.glideapps.com/t/group-my-tables-in-month-order-without-starting-with-april/74957/7 "2024-07-17T13:20:27Z")

</div>

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.

 ![Screenshot 2024-07-17 at 14.18.23](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2eec5c1598aaa8949d0265c09a17b891e4ecb64e.jpeg)
