# Add a Date Stamp when item is edited or submitted **URL:** \ **Category:** Ask for Help\ **Created:** [October 11, 2019, 3:30pm UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097 "2019-10-11T15:30:14Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![imorris](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/imorris/32/408_2.png) [@imorris](https://community.glideapps.com/u/imorris)\ **Post date:** [October 11, 2019, 3:30pm UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/1 "2019-10-11T15:30:15Z")
Client is using “Notes” to update each follow-up action in summary and must type in the date of the follow-up action to retain history of communications. Is there any way to date stamp current date each time they access that field to enter an update? ---
**Author:** ![Carlos\_DeSilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_desilva/32/19965_2.png) [@Carlos\_DeSilva](https://community.glideapps.com/u/Carlos_DeSilva)\ **Post date:** [October 11, 2019, 3:38pm UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/2 "2019-10-11T15:38:15Z")
You could add a Date Time Stamp under Special Components when used in a form. ---
**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:** [October 12, 2019, 2:28am UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/3 "2019-10-12T02:28:33Z")
If I recall your lead history notes, in that scenario, there is no way to track a date whenever a note component is edited. You would have to use a form button to submit notes to a new sheet with the date special value and the Lead name. Then use a reference to link the lead name to the lead name in the new sheet and display the notes as an online list. ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [October 12, 2019, 5:15pm UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/4 "2019-10-12T17:15:54Z")
I believe we offer special values in add and edit screens as well – not just forms. ---
**Author:** ![dmilleravid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dmilleravid/32/2230_2.png) [@dmilleravid](https://community.glideapps.com/u/dmilleravid)\ **Post date:** [August 13, 2020, 8:32pm UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/5 "2020-08-13T20:32:27Z")
I understand you can add the Special value “Date/time” component to a form to capture the posting date on a Form, but what about a Checklist? It’s a type of form but it doesn’t seem possible to log the date/time when a User marks an item “complete.” Or am I missing something? That would be super-useful for the app I’m working on now. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 13, 2020, 9:50pm UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/6 "2020-08-13T21:50:04Z")
As of now your best bet is to use a script that checks if those boolean columns are changed to True, then write the current timestamp to the destination column inside Google Sheets. ---
**Author:** ![siebe\_gorter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siebe_gorter/32/21194_2.png) [@siebe\_gorter](https://community.glideapps.com/u/siebe_gorter)\ **Post date:** [April 20, 2021, 10:04am UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/7 "2021-04-20T10:04:08Z")
I have the same question. did you find a useful solution? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 20, 2021, 10:09am UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/8 "2021-04-20T10:09:24Z")
Are you checking things using an inline list with checklist layout? ---
**Author:** ![BlakeWS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blakews/32/24377_2.png) [@BlakeWS](https://community.glideapps.com/u/BlakeWS)\ **Post date:** [April 20, 2021, 5:02pm UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/9 "2021-04-20T17:02:19Z")
Can this be done with an If / Then / Else column? If the (checkbox column) name is True, Then (code for date/time entry)? What I’m asking is, if in the Then field of the I/T/E column you can type a special value that would correspond to “Now”. (As well as other formulas.) ---
**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:** [April 20, 2021, 5:32pm UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/10 "2021-04-20T17:32:15Z")
You could create a math column to get Now then use it in an If Then column, but in a scenario like that Now will constantly be updating with the current datetime. You would have to instead write that datetime value to a static column so it doesn’t keep changing. But, if you are doing that, then you are better off getting the current datetime from the current date special value. ---
**Author:** ![BlakeWS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blakews/32/24377_2.png) [@BlakeWS](https://community.glideapps.com/u/BlakeWS)\ **Post date:** [April 20, 2021, 5:53pm UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/11 "2021-04-20T17:53:44Z")
> [@Jeff\_Hager](#): > > But, if you are doing that, then you are better off getting the current datetime from the current date special value. Okay, thanks. But to drill down on @dmilleravid 's question - what do we have to add to trigger this when a Checkbox is clicked? I don’t have this issue as I’m using a Button for the trigger, but I’m generally curious if there’s more functionality that I don’t know about for this. I can’t see additional functionality from the Checkbox component alone that would “Set columns” of the “Current date/time”. ---
**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:** [April 20, 2021, 6:29pm UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/12 "2021-04-20T18:29:20Z")
No, a checkbox will not call an action so you would have to use something that does allows for actions to be called. The examples in my post below allow for similar functionality to checking and unchecking a box, but without an actual checkbox. It could be simplified with a custom action to set a boolean column to true or false depending on the boolean’s current value. > [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211): > > There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n… ---
**Author:** ![siebe\_gorter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siebe_gorter/32/21194_2.png) [@siebe\_gorter](https://community.glideapps.com/u/siebe_gorter)\ **Post date:** [April 21, 2021, 5:46am UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/13 "2021-04-21T05:46:00Z")
yes exactly, and i would like to have a time and user stamp for cheking the box ---
**Author:** ![Albert\_Puig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/albert_puig/32/84707_2.png) [@Albert\_Puig](https://community.glideapps.com/u/Albert_Puig)\ **Post date:** [September 5, 2022, 4:23pm UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/14 "2022-09-05T16:23:02Z")
Hi there, Is it possible to do same thing but by using a normal button or picture as a trigger? I couldn’t find the way… Thanks ;)! ---
**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:** [September 5, 2022, 4:40pm UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/15 "2022-09-05T16:40:16Z")
You can apply actions to buttons or images. One of those actions can be a Set Column action that can update a date column with the Current Date/Time. Any component that allows you to set an action can set the current date time wherever you need it. ---
**Author:** ![Albert\_Puig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/albert_puig/32/84707_2.png) [@Albert\_Puig](https://community.glideapps.com/u/Albert_Puig)\ **Post date:** [September 13, 2022, 6:10pm UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/16 "2022-09-13T18:10:33Z")
Great, solved. Thanks ;)! ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/add-a-date-stamp-when-item-is-edited-or-submitted/1097/17 "2024-01-17T16:49:21Z")