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
Simon_Horup_Es1
6 - Interface Innovator
6 - Interface Innovator

This would be extremely useful!

Alan_Adamik
4 - Data Explorer
4 - Data Explorer

Is there any news on this topic ?

I believe it would be more appropriate to have a “default value” available on date type fields.
Setting the default value to whatever static date we want OR set it to “created_time()” or “updated_time()” would be an awesome feature !!

Keith_Taylor
5 - Automation Enthusiast
5 - Automation Enthusiast

+1 for this feature too please, folks. Thank you!

RobTX
6 - Interface Innovator
6 - Interface Innovator

Would love for this to be easier. Perhaps be able to select timezone as a field attribute using Customize? :grinning_face_with_big_eyes:

Justin
4 - Data Explorer
4 - Data Explorer

+1 for Date Modified which should automatically update a date and time when a row changes.

BenInDallas
7 - App Architect
7 - App Architect

Yes! Most other apps I’ve used offer auto-generated fields like date created, last modified date, created by, modified by, etc. Would definitely love to get these kind of options in AirTable.

stephanie_Caux
4 - Data Explorer
4 - Data Explorer

Hello,

same question, is it possible now?

Thanks

Tom
4 - Data Explorer
4 - Data Explorer

I’d like to second the points made above, this would be a killer feature for use in my company also. Absolutely loving so many of the great features airtable has so far, but the absence of a modified (or ‘completed’) timestamp feature presents an obstacle for us.

I haven’t been able to find a MODIFIED_TIME() feature within the table’s formula option yet - is this data available in some way via the API?

Sarandos_Kliki1
4 - Data Explorer
4 - Data Explorer

+1 for modified timestamp - could this also log which field was updated?

Andrew_Enright
9 - Sun
9 - Sun

+10 We need to be able to make a column hat tells us when the prior column was updated, per record.