Timestamp on updating a cell

[Rohan_Saneja]

Hi All

I have made a glide app where my sales users update the status of a lead. At the end of the day I want to track how many leads were updated using the date stamp of cell updated.

How to solve this? Attaching the screenshot, I want to check the date stamp when the ‘Current Status’ entry is filled.

[Jeff_Hager]

There is no way to automatically update a date column when you are changing the status directly on the detail screen.

Instead, if you use the Edit screen to change the status, then you can add a date time special value component that will insert the current date and time when the edit form is submitted.

Another option would be to have a user specific column to temporarily hold the status. Your choice component would fill the user specific column. On the way into the detail screen, you would set the user specific status column with the value in the status column. On the detail screen, you could have a Save or Submit button that copies the user specific status to the status. So a user could choose a status and click on a submit button directly on the detail screen, but that submit button could also set a date column.

The only other option would be some sort of script in a google sheet that could track when a status changes and update a date column, but that would be a lot of work for something simple. I would just use the Edit screen instead.

[Rohan_Saneja]

@Jeff_Hager

Instead, if you use the Edit screen to change the status, then you can add a date time special value component that will insert the current date and time when the edit form is submitted.

Can you please explain how to do this? I am very new to Glide Apps and just made the first app ever.

[Darren_Murphy]

Tap on the pencil icon at the top right.

That will take you to the Edit screen.
Add your input components on that screen, including an extra one for the datetime. Use the special value that Jeff mentioned for that.

Glide Docs • Current Date/Time

[Robert_Petitto]

@Jeff_Hager

Another option would be to have a user specific column to temporarily hold the status. Your choice component would fill the user specific column. On the way into the detail screen, you would set the user specific status column with the value in the status column. On the detail screen, you could have a Save or Submit button that copies the user specific status to the status. So a user could choose a status and click on a submit button directly on the detail screen, but that submit button could also set a date column.

This is what I would do

[HL_OF_SB]

Hi , I have been using edit screen to update time stamp by using special value component. But its seems no working on Edit screen for the last few days. Any issue on the special value component?
Thanks

[Jeff_Hager]

I haven’t had a chance to try it out myself, but it sounds similar to what’s happening in this thread, so I’m not sure if there is a bug or what’s going on.

Special value "User's email address" not working anymore

Hi, I have an application in production used daily by tens of users since 3rd of Jan. Today users reported me that something was going wrong. I found that special value “User"s emai address” is not set anymore. I use it to identify who has made the udpate of a record but this field is now left as blank… Any idea ? Any recent change ? Laurent