# Timestamp row creation date & time

**URL:** https://community.glideapps.com/t/timestamp-row-creation-date-time/69454
**Category:** Ask for Help
**Created:** [January 10, 2024, 7:14pm UTC](https://community.glideapps.com/t/timestamp-row-creation-date-time/69454 "2024-01-10T19:14:42Z")
**Posts on this page:** 11
**Page:** 1

<div class="post-metadata">

### Author: ![Kellar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kellar/32/69515_2.png) [@Kellar](https://community.glideapps.com/u/Kellar)
#### Post date: [January 10, 2024, 7:14pm UTC](https://community.glideapps.com/t/timestamp-row-creation-date-time/69454/1 "2024-01-10T19:14:42Z")

</div>

Is there an easy - or at least elegant - way to create a column that serves as a timestamp for the date and time a row gets created?

I’ve looked everywhere multiple times, and I’m not seeing it.

Thank you,

Shawn

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 10, 2024, 7:17pm UTC](https://community.glideapps.com/t/timestamp-row-creation-date-time/69454/2 "2024-01-10T19:17:26Z")

</div>

Add a date column. Then in your form add a Special Value component that populates it with the current date and time when the form is submitted.

---

<div class="post-metadata">

### Author: ![Kellar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kellar/32/69515_2.png) [@Kellar](https://community.glideapps.com/u/Kellar)
#### Post date: [January 10, 2024, 7:17pm UTC](https://community.glideapps.com/t/timestamp-row-creation-date-time/69454/3 "2024-01-10T19:17:40Z")

</div>

Thank you!

---

<div class="post-metadata">

### Author: ![Kellar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kellar/32/69515_2.png) [@Kellar](https://community.glideapps.com/u/Kellar)
#### Post date: [January 10, 2024, 7:23pm UTC](https://community.glideapps.com/t/timestamp-row-creation-date-time/69454/4 "2024-01-10T19:23:17Z")

</div>

@Jeff_Hager Hmm… I’m not seeing Special Values anywhere.

 ![Screenshot 2024-01-10 112259](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e8a5e63d81e3457d6ef1e6fce0c67903e375e043.png)

---

<div class="post-metadata">

### Author: ![MGA](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mga/32/50456_2.png) [@MGA](https://community.glideapps.com/u/MGA)
#### Post date: [January 10, 2024, 7:35pm UTC](https://community.glideapps.com/t/timestamp-row-creation-date-time/69454/5 "2024-01-10T19:35:39Z")

</div>

@Kellar

Its not a **Component** , look on the right side for **On Submit** :

 ![on-submit](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/d/0daead7fcfff62351da25b203d07e8bfed4fc867.png)

It will be added (using **Added/By** and **Added/On** ) whenever you insert a new record.

I also use **Updated/By** and **Updated/On** on record updates.

For more steps a custom action can be created.

---

<div class="post-metadata">

### Author: ![Kellar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kellar/32/69515_2.png) [@Kellar](https://community.glideapps.com/u/Kellar)
#### Post date: [January 10, 2024, 7:38pm UTC](https://community.glideapps.com/t/timestamp-row-creation-date-time/69454/6 "2024-01-10T19:38:11Z")

</div>

OH! got it. Thank you so much. I’m clear now.

---

<div class="post-metadata">

### Author: ![MGA](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mga/32/50456_2.png) [@MGA](https://community.glideapps.com/u/MGA)
#### Post date: [January 10, 2024, 7:49pm UTC](https://community.glideapps.com/t/timestamp-row-creation-date-time/69454/7 "2024-01-10T19:49:14Z")

</div>

You can also use this

![special](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e36615e53adc808b4dfd64ae9da56d7aafc4d653.png)

as @Jeff_Hager suggested but I usually use it the other way.

---

<div class="post-metadata">

### Author: ![Kellar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kellar/32/69515_2.png) [@Kellar](https://community.glideapps.com/u/Kellar)
#### Post date: [January 10, 2024, 8:00pm UTC](https://community.glideapps.com/t/timestamp-row-creation-date-time/69454/8 "2024-01-10T20:00:14Z")

</div>

@MGA Where is that on the interface? I couldn’t find it.

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 10, 2024, 9:08pm UTC](https://community.glideapps.com/t/timestamp-row-creation-date-time/69454/9 "2024-01-10T21:08:38Z")

</div>

> [@MGA](#):
>
> Its not a **Component**

I’d say it is a component because it’s added the same way a component is, but it’s just not visible.

> [@MGA](#):
>
> suggested but I usually use it the other way.

The problem I have with On Submit is that those actions are executed AFTER a row is added, and sometimes they run too quickly…before the row has been completely added. If you’re are not careful, they don’t always work. I’ve seen too many people have issues, especially relying on On Submit for something that can be done with the appropriate User Profile components, Special Value components, and Column Value components.

> [@Kellar](#):
>
> Where is that on the interface? I couldn’t find it.

Are you inside of a form? How are you saying rows?

---

<div class="post-metadata">

### Author: ![Kellar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kellar/32/69515_2.png) [@Kellar](https://community.glideapps.com/u/Kellar)
#### Post date: [January 10, 2024, 9:31pm UTC](https://community.glideapps.com/t/timestamp-row-creation-date-time/69454/10 "2024-01-10T21:31:40Z")

</div>

AH! I learned that I wasn’t setting the form up correctly. I was trying to do everything with components on the left-hand side, and I hadn’t set up the columns in the “form container” editor on the right-hand side. I think I have it now.

Such a robust system; extremely configurable, but definitely a learning curve.

Thanks @Jeff_Hager !

---

<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: [January 17, 2024, 9:32pm UTC](https://community.glideapps.com/t/timestamp-row-creation-date-time/69454/11 "2024-01-17T21:32:30Z")

</div>

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