# "Creating at" column and Group by Month **URL:** \ **Category:** Ask for Help\ **Created:** [February 17, 2024, 8:03am UTC](https://community.glideapps.com/t/creating-at-column-and-group-by-month/70905 "2024-02-17T08:03:48Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)\ **Post date:** [February 17, 2024, 8:03am UTC](https://community.glideapps.com/t/creating-at-column-and-group-by-month/70905/1 "2024-02-17T08:03:48Z")
Hello Gliders, I would like to achieve two things that seem quite simple, but I can’t seem to find the solution on the Community forum: 1. I would like a “Creating at” column that automatically records the moment when a user creates new item (so new row, as Notion natively offers it as a property). How can I do that? 2. I would like to group items in a collection by month, but Glide only provides a specific date. How can I do that? Thanks in advance for your help. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 17, 2024, 9:09am UTC](https://community.glideapps.com/t/creating-at-column-and-group-by-month/70905/2 "2024-02-17T09:09:32Z")
> [@GarryVa](#): > > I would like a “Creating at” column that automatically records the moment when a user creates new item (so new row, as Notion natively offers it as a property). How can I do that? You can pass the current date and time as a special (hidden) value with your form. > **[Current Date/Time | Glide Docs](https://www.glideapps.com/docs/reference/values/current-date-time)** > > Submit the current date and time automatically. > [@GarryVa](#): > > I would like to group items in a collection by month, but Glide only provides a specific date. How can I do that? Use a Math column with the following formula: ```auto Year(Date) * 100 + Month(Date) ``` You can then use that column to group the collection. ---
**Author:** ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)\ **Post date:** [February 17, 2024, 12:14pm UTC](https://community.glideapps.com/t/creating-at-column-and-group-by-month/70905/3 "2024-02-17T12:14:24Z")
Thank you so much Darren for your help, it’s very clear I will try. About grouping by month, I understand what result this will show but to go a bit further and be able to show something more friendly to my users, how to group by month with months in full words? For example, in French, the result would be « Février 24 » or « Février 2024 », both are ok. Best, ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 17, 2024, 12:22pm UTC](https://community.glideapps.com/t/creating-at-column-and-group-by-month/70905/4 "2024-02-17T12:22:25Z")
I thought you might ask that 🙂 A simple way is to use the [Format Date](https://www.glideapps.com/plugins/format-date) column. But just a word of caution - that column has been known to be unreliable on IOS devices in some circumstances. But give it a try, it might work fine for you. If it doesn’t, come back and I will give another method that will be more reliable, but involves a bit more work. ---
**Author:** ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)\ **Post date:** [February 17, 2024, 12:46pm UTC](https://community.glideapps.com/t/creating-at-column-and-group-by-month/70905/5 "2024-02-17T12:46:30Z")
I didnt even know that plugins existed on Glide. Thank you, I will try it as well and be back to you. I understand that this plugin works on its own, I don’t need your initial Math formula anymore 👍🏼 Let’s try ---
**Author:** ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)\ **Post date:** [February 19, 2024, 3:06pm UTC](https://community.glideapps.com/t/creating-at-column-and-group-by-month/70905/6 "2024-02-19T15:06:10Z")
Hello @Darren_Murphy, I finally tried your solutions and it looks to work, thank you so much. Do you have any idea how I can translate month’s name with the plugin you suggest ? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/903b0ab398b628796b7326cd103176aef0d40d24.png) I didn’t find anything here : [luxon - Immutable date wrapper](https://moment.github.io/luxon/#/formatting?id=table-of-tokens) Best, ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 19, 2024, 3:32pm UTC](https://community.glideapps.com/t/creating-at-column-and-group-by-month/70905/7 "2024-02-19T15:32:18Z")
Use `MMMM` ![CleanShot 2024-02-19 at 23.31.38@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/f/2fd0e6c26b72a385dd796bc8cee369ba19567948.png) ---
**Author:** ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)\ **Post date:** [February 19, 2024, 4:03pm UTC](https://community.glideapps.com/t/creating-at-column-and-group-by-month/70905/8 "2024-02-19T16:03:08Z")
This is what I did but look, it’s in english, and I would like to translate in french : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/c/ac32da80d6e03193aeaedd554e25997e98798dbe.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 19, 2024, 4:14pm UTC](https://community.glideapps.com/t/creating-at-column-and-group-by-month/70905/9 "2024-02-19T16:14:55Z")
ah, I’m not sure about that, sorry. You could do it without using the Format Date column, but it’s a bit more complicated. But anyway, here is how: - Create a separate table that lists the names of the months (in French) all in a single column, one per row - In your data table, create a Math column to get the Month Index from the Date. Use the following formula: `Month(Date)-1` - Add a Single Value column, and configure it to take X from start of your Month List column, where X is the Month Index (the Math column) ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [February 26, 2024, 4:15pm UTC](https://community.glideapps.com/t/creating-at-column-and-group-by-month/70905/10 "2024-02-26T16:15:43Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.