# Last Update Date/Time whenever a cell/row is changed in Tables (Glide/GS) **URL:** \ **Category:** Ask for Help\ **Created:** [November 13, 2021, 6:14pm UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471 "2021-11-13T18:14:24Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [November 13, 2021, 6:14pm UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471/1 "2021-11-13T18:14:24Z")
Hi šŸŒø I have a Knowledge Base, where I create & update contents in Glide and or GS tables depending on the length of texts. Many entries are still in progress, so I use a jauge to show % WIP, next to completion, etc. I have a date/time column that I update manually, since I notice my =Today() in GS computes the date for all rows whenever I update 1 cell only. How am I supposed to save the Last Updated Date/Time for the row and not the entire table/GS (tab). Ideally from Glide columns Is there already a Feature Request for Last Update, Last Accessed/Read? Thks šŸŒø ---
**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:** [November 13, 2021, 6:46pm UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471/2 "2021-11-13T18:46:10Z")
In many of my tables, I have the following columns: - Created At (date/time) - Created By (text) - Updated At (date/time) - Updated By (text) When a record is created (Add Row), the Created At column is populated with the current date/time, and the Created By column is populated with the signed in users UserID. When a record is updated (Set Column Values), the Updated At column is updated with the current date/time, and the Updated By column is updated with the signed in users UserID. So I get something that looks like this: ![Screen Shot 2021-11-14 at 2.45.04 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cb8f01a0bdeb2f50d916ad9ed24e83be11226b8a.png) ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [November 13, 2021, 6:56pm UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471/3 "2021-11-13T18:56:44Z")
Yes, thatā€™s what I do - already - for my Add Row. But, how can I do if I manually update rows in Glide or GS Tables? I update the dates manually as well? (there are many columns to scroll horizontally depending what cells Iā€™m updating) Thatā€™s my tedious current process. And thereā€™s not date picker. Thks šŸ™‚ ---
**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:** [November 13, 2021, 11:21pm UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471/4 "2021-11-13T23:21:36Z")
> [@L.M](#): > > But, how can I do if I manually update rows in Glide or GS Tables? I update the dates manually as well? Short answer is you canā€™t, only way is you edit them through the edit screen and use an on submit action. ---
**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:** [November 14, 2021, 2:03am UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471/5 "2021-11-14T02:03:32Z")
> [@L.M](#): > > But, how can I do if I manually update rows in Glide or GS Tables? Isnā€™t that kind of defeating the purpose of having the app? > [@L.M](#): > > And thereā€™s not date picker. ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [November 14, 2021, 5:23am UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471/6 "2021-11-14T05:23:31Z")
> [@ThinhDinh](#): > > only way is you edit them through the edit screen and use an on submit action. yes Iā€™ve noticed than I can set the current date/time for ex in form screen, hence my surprise not seeing the same simple option to prefill with user name an input field component in a Detail Layout. What do you call ā€œedit screenā€? the click inside the cell from the Glide Table? ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [November 14, 2021, 5:30am UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471/7 "2021-11-14T05:30:53Z")
Oh! A Date Picker! OK. I havenā€™t catch that Glideā€™s very invisible style šŸ‘» Merci. Because Glide keeps on having trouble letting me edit JJ/MM/AAAA (though it does display it my way) and displays/interpret it MM/JJ/AAAA: I had to try several times. So this month, any date is often the 11th of any other month but november, instead of being november of well todayā€™s day name. šŸ™„ ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 14, 2021, 5:42am UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471/8 "2021-11-14T05:42:47Z")
you can add a triggered script to your sheet, so every time you edit itā€¦ it will change the timestamp to a current one, [LINK TO SCRIPT](https://code-book.glideapp.io/dl/ewAiAHQAIgA6ADQALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0AUwBjAHIAaQBwAHQAcwAiACwAIgByACIAOgAiAEQAdwB6AFQAcQA2AC4AcwBRAHgAUwBBAFIAegBTAEgAVwB5AGEAdwBvAHcAIgAsACIAbgAiADoAIgBTAGMAcgBpAHAAdAAiAH0A) ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [November 14, 2021, 5:55am UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471/9 "2021-11-14T05:55:23Z")
But I just tried: when I edit, thereā€™s no date picker, only my date in edit mode, and from the initial samedi 13 novembre 2021, itā€™s edited like 13/11/21 (JJ/MM/YY) which is correct. šŸ˜ž ---
**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:** [November 14, 2021, 6:35am UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471/10 "2021-11-14T06:35:08Z")
That date picker example I gave is from a Google Sheet. There is no such option in the Glide Data Editor. But again, Iā€™d question why you are editing data in the GDE? Normally you wouldnā€™t do that unless you are testing something. ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [November 14, 2021, 6:38am UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471/11 "2021-11-14T06:38:51Z")
As I said: my app is a knowledge base, with \> 150 glossary entries I update myself (definitions, videos, links, images), not a bulk import. As an Instructor, I rewrite everything for clarity and topic better understanding + skills transfer. The content changes whenever necessary, to adjust to fresh info about Product Management. ---
**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:** [November 14, 2021, 6:42am UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471/12 "2021-11-14T06:42:26Z")
uh-huhā€¦ > **[Adding & Editing](https://docs.glideapps.com/all/courses/introduction-to-pages/adding-and-editing)** ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 14, 2021, 6:47am UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471/13 "2021-11-14T06:47:21Z")
add this script to your google sheet, and it will time stamp automatically every time you make a change: > **[Code BOOK](https://code-book.glideapp.io/dl/ewAiAHQAIgA6ADQALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0AUwBjAHIAaQBwAHQAcwAiACwAIgByACIAOgAiAEQAdwB6AFQAcQA2AC4AcwBRAHgAUwBBAFIAegBTAEgAVwB5AGEAdwBvAHcAIgAsACIAbgAiADoAIgBTAGMAcgBpAHAAdAAiAH0A)** > > share cool codes, scripts and links ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [November 14, 2021, 6:51am UTC](https://community.glideapps.com/t/last-update-date-time-whenever-a-cell-row-is-changed-in-tables-glide-gs/34471/14 "2021-11-14T06:51:59Z")
Ah good idea, butā€¦ 1/as a newbie, I was at the beginning afraid of setting visibility conditions not good enough (I know how with other environments, but not sure about ā€œreal Glide behaviorā€ to trust it months ago) 2/since I set user click tracing, if I update using this edit UI, Iā€™ll have to delete all the tracing ā€œAdd rowsā€ because of my own clicks to open each screen. More tedious than updating dates in tables. BTW, yes, the GS update with date picker is ok, thks. I replaced all Today() by a fixed date. Curiously, Glide does not seem to count all the edits (should be close to 100 or more). Letā€™s wait and see.