"Creating at" column and Group by Month

Ask for Help
1

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?

    image
    image800×788 50.4 KB

  2. I would like to group items in a collection by month, but Glide only provides a specific date. How can I do that?

    image
    image1016×1100 83.7 KB

Thanks in advance for your help.

2

You can pass the current date and time as a special (hidden) value with your form.

Use a Math column with the following formula:

Year(Date) * 100
+ Month(Date)

You can then use that column to group the collection.

2 Likes
3

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,

4

I thought you might ask that :slight_smile:

A simple way is to use the 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.

1 Like
5

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 :+1:t3: Let’s try

6

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

I didn’t find anything here : luxon - Immutable date wrapper

Best,

7

Use MMMM

CleanShot 2024-02-19 at 23.31.38@2x
CleanShot 2024-02-19 at 23.31.38@2x816×728 56.3 KB

8

This is what I did but look, it’s in english, and I would like to translate in french :
image

9

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)
1 Like
10

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.