Skip to main content

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

Would it be possible to add the “updated time” to the API response for each row returned?


This is quite necessary specially when building synchronization applications. By knowing the last time a row was updated, we can either trigger a call to synchronize it or skip it completely. This would decrease the load on Airtable’s side by a lot. Currently developers are forced to just update every single record on Airtable every x hours because there is no way to know whether a record was updated or not. I can force updates on specific records by adding my own timestamp every time I synchronize but that still requires a manual process.


Thanks

Try adding your voice here: Last Modified Timestamp

+1 for this feature. Have several people updating a database of company records and another database of NGOs and volunteers and would love to know when we last updated info about each.

+1 - Add me to the list. Any ETA for then this update will be available?




    1. Need last modified timestamp



Obligatory “why is this not implemented yet?”

So when i edit content. And expand the view it actually has the modify date right inside there.

Would it not be easy to use this as a reference for the code?

+1 any update on this?

@Airtable_Team @Airtable_Support Hello?

any updates @Airtable_Team

+1 for this feature as well

Also +1 for this feature. Would be great to hear an update @Airtable_Team

Finishing up building a new product info system and looking for this feature as well before we start sharing access to a wider group.

Add yet another to the list requesting LAST_MODIFIED().

Airtable Team: It looks like this request has been floating out there for quite a while - any updates?

It looks like there’s plenty of support for this already, but wanted to make sure I put my name down for a last modified field as well!!

+1 for Last Modified Timestamp … essential

+1. Created Time is great, but adding these remaining missing cols would be incredibly helpful:



  • created user

  • last modified time

  • last modified user

+1 for date / time of record modified

+1!!! Need this to try and move into using AT as frontend

c’mon guys. This is a no brainer. Please give us an update +1

Yet another reminder. @Airtable_Support, can you please at least respond to all of us here and tell us whether you still plan to do this, and when a realistic release date might be?

+1, just want to add my voice here.

yes a very critical feature request, make it your first priority please


adding a handful of new field types



  • created time

  • last modified time

  • created by user

Please can you give us a timeline of either this, or webhooks for updated records? This is one of the things that would really be holding us back from migrating a CRM. Right now there isn’t really a good way to integrate with a marketing automation system, as there isn’t an easy way for us to sync the marketing contacts with the airtable records… We would constantly have to loop through all the records and check that the object is the exact same in both systems.

Would Love a last modified/updated timestamp!

Reply


Terms & Conditions