# How can I record the date a form is submitted on Coda?

**URL:** <https://connect.superhuman.com/t/how-can-i-record-the-date-a-form-is-submitted-on-coda/24146>\
**Category:** Ask the Community\
**Created:** [June 21, 2021, 9:31am UTC](https://connect.superhuman.com/t/how-can-i-record-the-date-a-form-is-submitted-on-coda/24146 "2021-06-21T09:31:07Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Khalid\_W\_Abou\_Kassem](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/khalid_w_abou_kassem/32/21518_2.png) [@Khalid\_W\_Abou\_Kassem](https://connect.superhuman.com/u/Khalid_W_Abou_Kassem)\
**Post date:** [June 21, 2021, 9:31am UTC](https://connect.superhuman.com/t/how-can-i-record-the-date-a-form-is-submitted-on-coda/24146/1 "2021-06-21T09:31:07Z")

</div>

I created a form to make it easier for my colleagues to share their new hiring needs, and I need to record when a form is submitted. I tried multiple ways:

1. Adding a date and time field to the form
2. Adding a date created column to the table

And much more, none of which are working. Any suggestions?

---

<div class="post-metadata">

**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\
**Post date:** [June 21, 2021, 9:41am UTC](https://connect.superhuman.com/t/how-can-i-record-the-date-a-form-is-submitted-on-coda/24146/2 "2021-06-21T09:41:02Z")

</div>

hi @Khalid_W_Abou_Kassem , did you try to use `Modified(thisRow)` ?

 ![image](https://global.discourse-cdn.com/coda1/original/3X/3/2/320532833e85fb44459673403b5c9d69f63aad4a.png)

Cheers, Christiaan

---

<div class="post-metadata">

**Author:** ![Khalid\_W\_Abou\_Kassem](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/khalid_w_abou_kassem/32/21518_2.png) [@Khalid\_W\_Abou\_Kassem](https://connect.superhuman.com/u/Khalid_W_Abou_Kassem)\
**Post date:** [June 21, 2021, 9:57am UTC](https://connect.superhuman.com/t/how-can-i-record-the-date-a-form-is-submitted-on-coda/24146/3 "2021-06-21T09:57:36Z")

</div>

Yes, it would only show the date I manually create or modify a row in the table. Any other suggestions mate? Thanks.

---

<div class="post-metadata">

**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\
**Post date:** [June 21, 2021, 10:14am UTC](https://connect.superhuman.com/t/how-can-i-record-the-date-a-form-is-submitted-on-coda/24146/4 "2021-06-21T10:14:54Z")

</div>

I am afraid I miss out on something obvious : when a table (form) is filled out, the user create a new row and thus the outcome of `Modified(thisRow)` changes as well. Then you have the creation data. What is it I do not see?

---

<div class="post-metadata">

**Author:** ![Khalid\_W\_Abou\_Kassem](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/khalid_w_abou_kassem/32/21518_2.png) [@Khalid\_W\_Abou\_Kassem](https://connect.superhuman.com/u/Khalid_W_Abou_Kassem)\
**Post date:** [June 21, 2021, 11:30am UTC](https://connect.superhuman.com/t/how-can-i-record-the-date-a-form-is-submitted-on-coda/24146/5 "2021-06-21T11:30:14Z")

</div>

Hey Christiaan. I loomed a video for your reference just to simplify what I mean.

---

<div class="post-metadata">

**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\
**Post date:** [June 21, 2021, 11:40am UTC](https://connect.superhuman.com/t/how-can-i-record-the-date-a-form-is-submitted-on-coda/24146/6 "2021-06-21T11:40:24Z")

</div>

thx for the video @Khalid_W_Abou_Kassem , it helps 😉

**in short for those interested.** the `Modified(thisRow)` works well when you are in Coda and you modify or create a row. However when you have a form embedded and the data comes in, the `Modified(thisRow)` remains blank, does not work. That surprises me.

@Federico.Stefanato , do you have a work around for this?

---

<div class="post-metadata">

**Author:** ![Federico.Stefanato](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/federico.stefanato/32/21115_2.png) [@Federico.Stefanato](https://connect.superhuman.com/u/Federico.Stefanato)\
**Post date:** [June 21, 2021, 11:48am UTC](https://connect.superhuman.com/t/how-can-i-record-the-date-a-form-is-submitted-on-coda/24146/7 "2021-06-21T11:48:09Z")

</div>

Hi @Khalid_W_Abou_Kassem (and welcome to the Community!), and @Christiaan_Huizer,

In your Timestamp column you might try to use the **Value for new rows** option to `Now()` (and obviously hide it in the form view).  
This should value the column as it is computed _once_ the row is actually created.

![Untitled 2](https://global.discourse-cdn.com/coda1/original/3X/1/1/116919acfa7094209383f9194d998cd7e3c183b8.jpeg)

Let me know if this helps.  
Cheers!

---

<div class="post-metadata">

**Author:** ![Khalid\_W\_Abou\_Kassem](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/khalid_w_abou_kassem/32/21518_2.png) [@Khalid\_W\_Abou\_Kassem](https://connect.superhuman.com/u/Khalid_W_Abou_Kassem)\
**Post date:** [June 21, 2021, 12:09pm UTC](https://connect.superhuman.com/t/how-can-i-record-the-date-a-form-is-submitted-on-coda/24146/8 "2021-06-21T12:09:42Z")

</div>

Yep, that worked out perfectly well. Thanks gentlmen!
