Last modified time [SOLVED]

[Katherine_Duh]

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.)

[Katherine_Duh]

Moving this discussion into the feature requests section.

[Katherine_Duh]

Moving this discussion into the feature requests section.

[Tim_Dietrich]

Is there a way to get a record’s creation and/or last modified timestamp?

Perhaps using a formula field or through meta info provided through the API?

~ Tim

[Raijin_Rising]

I’d like to have a column in a database that only updates a cell when that record has been added or updated. There is a field type for auto updating when the record is created but not when a record is altered in any way.

[Ron_Kagan]

Thank you for moving this here. Insofar as it is possible to vote for a feature, this has my vote

[darren_mark]

great! is there a time frame for implementation? this is pretty much holding us back from a paid membership.

[David_Von_Lehma]

I don’t know if Heart’ing previous posts or replying is the best way to cast a vote for “LAST_MODIFIED”, but it is critical for us as well. Pretty please??

[Jesal_Trivedi]

+1 here guys. this is absolutely crucial for my team.

[Eli_Silverman]

+1 I’m a recent convert to Airtable and think it’s a beautiful and great product. However, it’s incredibly surprising this feature hasn’t been implemented yet, especially after almost two years of discussion… I’m writing an API integration with Airtable that imports into another DB and this makes tracking changes and updates a nightmare. It’s not even a large Base! If you’re performing operations on multiple related tables, not having a modified timestamp forces you to write something client side and/or make dozens of API calls and it’s a huge performance issue. I guess Airtable is forming the dev roadmap based on it’s broadest demographics, but this seems like a such a no-brainer for any service that wants to be able to perform like a CMS…

[Tiziano_Marmiro]

+1 for “last modified” as well! We need it!