# Create a formula created date automatically

**URL:** https://community.glideapps.com/t/create-a-formula-created-date-automatically/74732
**Category:** Ask for Help
**Created:** [July 9, 2024, 7:05am UTC](https://community.glideapps.com/t/create-a-formula-created-date-automatically/74732 "2024-07-09T07:05:44Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Thomas\_Scorticati](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_scorticati/32/61870_2.png) [@Thomas\_Scorticati](https://community.glideapps.com/u/Thomas_Scorticati)
#### Post date: [July 9, 2024, 7:05am UTC](https://community.glideapps.com/t/create-a-formula-created-date-automatically/74732/1 "2024-07-09T07:05:44Z")

</div>

Hello everyone,

When an user creates a record like a new row on Glide table, I want a column informs about the new row’s creation date.

I tried to make it with current time but the date changes everyday.  
I want the date blocked at the created date.

How could do I do it ?

Thank you

---

<div class="post-metadata">

### 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: [July 9, 2024, 9:14am UTC](https://community.glideapps.com/t/create-a-formula-created-date-automatically/74732/2 "2024-07-09T09:14:11Z")

</div>

Sounds like you are using a computed column for the date?

You should use a non-computed date/time column, and populate that with the current date/time as each new row is created.

> **[Current Date/Time | Glide Docs](https://www.glideapps.com/docs/reference/values/current-date-time)**
>
> Submit the current date and time automatically.

---

<div class="post-metadata">

### Author: ![Thomas\_Scorticati](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_scorticati/32/61870_2.png) [@Thomas\_Scorticati](https://community.glideapps.com/u/Thomas_Scorticati)
#### Post date: [July 9, 2024, 10:07am UTC](https://community.glideapps.com/t/create-a-formula-created-date-automatically/74732/3 "2024-07-09T10:07:36Z")

</div>

Where do I find the non-coputed column ?  
I created a basic Date/tome as you can see on the picture.

And I created an action as you can see on the second picture.  
But it does seem to work.

How could I do it ?

Thank you so much

![Screenshot 2024-07-09 at 12.06.11](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/d/fd97911527817d9423049d18edc5d2b907e6891e.png)

 ![Screenshot 2024-07-09 at 12.07.07](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/2/b2960fa1079fcd964e7fc8a6282e07f83b687cb0.png)

---

<div class="post-metadata">

### 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: [July 9, 2024, 10:18am UTC](https://community.glideapps.com/t/create-a-formula-created-date-automatically/74732/4 "2024-07-09T10:18:54Z")

</div>

Don’t use Set Column values as an onSubmit action with a Form.  
Pass the date/time as a special value with the form. The document that I linked to tells you how to do this.

---

<div class="post-metadata">

### Author: ![Thomas\_Scorticati](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_scorticati/32/61870_2.png) [@Thomas\_Scorticati](https://community.glideapps.com/u/Thomas_Scorticati)
#### Post date: [July 11, 2024, 11:48am UTC](https://community.glideapps.com/t/create-a-formula-created-date-automatically/74732/5 "2024-07-11T11:48:35Z")

</div>

Ho I did not see your link and it worked so well.  
Thank you a lot 🙂  
Thomas

---

<div class="post-metadata">

### 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: [July 18, 2024, 11:48am UTC](https://community.glideapps.com/t/create-a-formula-created-date-automatically/74732/6 "2024-07-18T11:48:36Z")

</div>

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