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

[Matt_Bush]

Update from Airtable team: Created Time is now available as its own field type, in addition to a formula function.

We’re working on some system upgrades to support a modified time field as well, and plan on making that available soon.

[Matt_Bush]

Update from Airtable team: Created Time is now available as its own field type in the type picker, in addition to the existing formula function.

We’re working on some system upgrades to support a last modified time field as well, and plan on making that available soon.

[Bernard_Toure]

Hi,
Great news to ear the last modified coming.
A side question is, will that update will make an “on update” trigger
available in zapier intégration ?
Cheers

[Matt_Bush]

Separately from the Last Modified field, we are looking into adding support for webhooks and on-update triggers in the longer term.

The Last Modified field won’t include those changes, but it will enable a workaround for them, which is querying the Airtable API only for records modified after a specific date and time.

[Chris_Moyer]

Any clarification on “soon”? within the next few months?

[Dan_Weaver]

@Matt_Bush surely you guys are storing LastModified behind the scenes? Isn’t that standard across pretty much all databases? Exposing that as a column seems like a low-effort, high-return type of feature.

[Frank_Norrmann]

Do you have an ETA for the modified time field feature?

[Kumar_Indresh]

any update on the modified time value?

[George_Efstathi]

Hello there,
I have recently signed up for airtable to give it a try and this is the second important thing in my layout (after created time).
Any news if and when this is going to be available?

Best regards

[Craig_Cox]

I am evaluating Airtable, and having a “Last Modified” option would enable me to use it as a full-featured CRM. Any update on when the features discussed in @Matt_Bush’s post of June 15th will be available to use?

This is a great app, and I look forward to a Last Modified feature. Thanks.