Hey, Is there a simple way to record the creation date and modification date of an item created via a Glide app ? For exemple somebody create a new item, and in one column of the line in the Google Sheet, the current date / time is automatically recorded. I managed to do something with a google s…

This might help your case. [image] Time stamp update Ask for Help Hi John, sorry for the late reply but here’s the working script. // The column you want to check if something is entered. var COLUMNTOCHECK = 2; // Where you want the date time stamp offset from the input …

[image] caffinho: For exemple somebody create a new item, and in one column of the line in the Google Sheet, the current date / time is automatically recorded. You can also record this via the special value component in the Glide form. For the modification part, you can check my script, linke…

Yes, as always a reminder that onChange works with updates from Glide, onEdit doesn’t and seems like onFormSubmit is the same. [image] Time stamp update Ask for Help Hi, I would like to suggest you changing from onEdit to onChange and see what happens when you edit the ch…

OK, I didn’t know that about the Glide form. Looks useful as well. Thank you !

Could you just do this all with the date time special value? Only fill a Created column when in Add or Form mode, and only fill the Modified column when in Edit mode.

Now I see what you are talking about @Jeff_Hager but here i just want to record the date at which a user selected a date through a date picker (not on a add or edit or form mode :frowning: ) @ThinhDinh i feel like you are one of the experts here in Google Script and I am struggling with my script. …

It’s really strange as I don’t see any problems with the script. Is there any chance you have left empty rows inside the sheet and the new record is written to row 501 or 1001?

there is no fully empty row in the sheet no :frowning: just sometimes some empty cells on a row but that’s all. could these empty celles be a problem you think ? when this date picker is used it’s never in the context of adding a new row. The row always already exists and already has some stuff on …

But so far, has it affected the values that you want to be recorded?

Very good question. and the answer is yes… absolutely. let’s say there are 5 errors one day, 1 to 3 of these errors affect what I am trying to do … sometimes more…

Record creation date / modification date of an item

Ask for Help

caffinho June 5, 2020, 3:56pm 4

Thank you ! just changing onFormSubmit to onChange made it work just fine !!

1 Like

Topic		Replies	Views
Time stamp update Ask for Help	84	7456	August 17, 2022
Timestamp on switch action Ask for Help	32	2366	April 7, 2022
Row Modified timestamp Ask for Help	14	1436	December 8, 2020
Get Last Modified Date When Cell is changed Ask for Help	4	1895	September 2, 2020
Last Update Date/Time whenever a cell/row is changed in Tables (Glide/GS) Ask for Help	13	1591	November 14, 2021

Record creation date / modification date of an item

Related topics