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
Matt_Langston
5 - Automation Enthusiast
5 - Automation Enthusiast

Any update on the last modified time?

David_Huck
5 - Automation Enthusiast
5 - Automation Enthusiast

Any updates? Would love to have last modified for an inventory sheet

David_Berg
4 - Data Explorer
4 - Data Explorer

It does not appear that this functionality made it into Airtable in the coming months. True?

db

Tiffany_Hamilto
4 - Data Explorer
4 - Data Explorer

Hi Matt, I would like to add that the modified date and the user who created a record would be VERY helpful to our team in order to streamline our workflow as well. We are loving AirTable so far, just need those two features to really make it great.

Any ETA on those features?

Much appreciated! Keep up on the great product!

Thanks!
Tiffany

Polina_Hanin
4 - Data Explorer
4 - Data Explorer

Hey Matt - would be great to know when this workaround is coming. Thanks!!

Christopher_O_K
4 - Data Explorer
4 - Data Explorer

Hey team - any updates?

Darryl_Holliday
5 - Automation Enthusiast
5 - Automation Enthusiast

Any ideas on how to edit the Created Date field? I was manually logging created dates until discovering the field today. I need to edit all of the rows prior to today with the correct “created date” but it seems the field can’t be edited.

Peter_Banks
4 - Data Explorer
4 - Data Explorer

Hi - are there any updates on when a Last Modified Date will be available. Or if there is a workaround to show the records that have been recently changed.

W_Vann_Hall
13 - Mars
13 - Mars

As far as I know, the field can’t be edited. Something I’ve used before is to create a ‘created override’ column — essentially the manually-logged dates you currently have — and a ‘created’ column. The last is a formula field with the following configuration:

IF({Override}!="",{Override},CREATED_TIME())

This allows you to pick up the internal created timestamp as a default but allows you to override it manually if necessary. Presumably, at some point in the future, after aging out the last record requiring the override, you can delete the override column and set {Created} to be a field of Created_Time type.

Chris_Lu
6 - Interface Innovator
6 - Interface Innovator

Agreed with all above, the lack of a last modified timestamp is preventing us from using Airtable on a company-wide scale.

Is there any news on when this might become available?