Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Last modified time [SOLVED]

cancel
Showing results for 
Search instead for 
Did you mean: 
Katherine_Duh
Airtable Alumni (Retired)
Status: Launched

UPDATE 2: last modified time is now available to everyone! You can learn more about it here.

UPDATE: The last modified time beta is now closed as we get ready for a general release. Thanks to all of the testers who made this beta a success.

ORIGINAL POST:

Hi folks! We’re very excited to announce that we’re beta testing a last modified time field type, as well as a LAST_MODIFIED_TIME formula function. Many thanks to the users who’ve posted specific, detailed feedback about their needs and use cases with regard to this feature, like @Arlo_Haskell, @Deborah_Buck, and @Jordan_Friedman. We read everything that is posted here in the forums and your feedback is incredibly valuable for us when we’re planning the product roadmap and developing new features!

If you’re a Pro plan user and you’re interested in testing out the last modified time field type and/or the LAST_MODIFIED_TIME formula function—and giving us your feedback—please sign up using this form. (Note: this is a different form from our standard beta signup form, and it requires you to fill out a couple of additional questions.)

As you are all aware, this is a highly anticipated feature, and there are many users who would like to get beta access. However, for technical reasons and to ensure an optimal user experience, rollout for this beta will be conducted in small, limited batches. (In practical terms, that means that it might take a while for you to get access.)

219 Comments
Gary_M
4 - Data Explorer
4 - Data Explorer

+1 for last modified time-stamp, or last modified date, etc. MUST HAVE – needing to create a unique table view that aggregates records that have changed.

agg_kafer
4 - Data Explorer
4 - Data Explorer

It’s been a while @Andrew since your last post. Are there any reasons why modified date takes so long to be implemented?

Andrew_Enright
9 - Sun
9 - Sun

Once again, I’m on the hunt for a formula that displays the date AND time that another field was checked (checkbox field). We need a way to timestamp releases of files and the easiest way is to check off the task. Checking it off should then result in a timestamp in an adjacent or referencing field/column.

Right now we are using:

IF(Checked=1, TODAY())

But that doest not return the time, and is seemingly not a persistent timestamp. Ideally we’d have a formula that updates only when the referenced field/column is updated (checked/unchecked).

Tuur
10 - Mercury
10 - Mercury

NOW() returns day and time. :slightly_smiling_face:

Andrew_Enright
9 - Sun
9 - Sun

Alas… The NOW function updates every time you refresh the sheet (pretty sure). What we need is a persistent timestamp that does not change until/unless the associated trigger field (checkbox) is modified (checked/rechecked).

Tuur
10 - Mercury
10 - Mercury

Sure does. I was only responding to your observation that TODAY does not have a time component.

It also updates every time you refresh, but you’ll only notice that the other day of course. :winking_face:

Tuur
10 - Mercury
10 - Mercury

By the way, if you really need this, I can create a custom solution for you. Drop me a message in case you’re interested. :slightly_smiling_face:

Chris_Dols
4 - Data Explorer
4 - Data Explorer

+1 from a new user. Would be very useful.

Paco_Higham
5 - Automation Enthusiast
5 - Automation Enthusiast

Would it be possible to make a field type that would update with the last update of the Revision History? It would be awesome for us to track exactly where projects/comments are in real-time just by looking at our overview sheet.

Is there a way to currently do this? If not, is there any chance that this could be added in a future release?

paco

Zac
6 - Interface Innovator
6 - Interface Innovator

Hi Matt, is this still being planned?