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
Ben_Zhuk
4 - Data Explorer
4 - Data Explorer

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?

Caleb_Hicks
4 - Data Explorer
4 - Data Explorer

+1, just want to add my voice here.

abdou_justsmile
4 - Data Explorer
4 - Data Explorer

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

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.

Karo_Castro-Wun
4 - Data Explorer
4 - Data Explorer

Would Love a last modified/updated timestamp!

Carlos_Caban
4 - Data Explorer
4 - Data Explorer

+1 For last modified field or webhooks. Is there a mailing list we can get on for specific feature updates?!? Much appreciated!

Miles_Blackwood
4 - Data Explorer
4 - Data Explorer

+1 It looks like the feature is in development? It’d be nice to at least hear what the progress has been.

Nicholas_Ewing
5 - Automation Enthusiast
5 - Automation Enthusiast

+1 Would love to see the last modified feature as well.

Karo_Castro-Wun
4 - Data Explorer
4 - Data Explorer

+1 on last modified request!

Arlo_Haskell
7 - App Architect
7 - App Architect

Hello. I’d also like to see a Last Modified function, to tell me when a record or even a given field in a record was last modified. Similar to the extant CREATED_TIME() function.

We use Zapier’s “new record in view” trigger to build a MailChimp mailing list for upcoming events. Sometimes an email address changes. Ideally I would use the Last Modified function in a filter that shows me only those records where the email address has changed since the date of event-ticket purchase.

I gather from the thread here that this has been in progress for some time. Hope to see it rolled out soon.

Thank you.