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

@Katherine_Duh is there any update on the status of our application?

Where are we at with this? 100% need a date/time stamp for last modified record @Katherine_Duh

Is there any tentative date for wide release of this feature?

Hi All,

I think we have no option of modified date of records, can you please add a new features in the on records,

So we can get easily the updated date of records.

Also please let us know if we can create a formula for the getting updated or Modified date of records.

Thanks in advanced

What I find lacking over and over again is time when a field(not record) was last updated.


Example: I have a field status. I need to know when the status was changed from In Progress to Completed. That way I can group all Completed tasks by month and calculate pay for this month.


I think it is not too much to ask and it is a very basic and must-have feature for a project manager softwaer.


Agreed 100%, I could really use a feature like this for creating burndown charts.

What is the target delivery date for this feature? I just started using Airtable, which I really like, but this feature is important. Coming from the world of SharePoint custom lists I was a bit stunned to see this column did not exist.


Does this mean you’ll also be implementing the field ‘Last Modified By’? I ask because ‘Last Modified Date’ and ‘Last Modified By’ go hand in hand. In the same context, a ‘Created By’ field would also be important to have.

Following. Glad to see this feature is being actively developed! Looking forward to using it in the wild, especially if it improves integration with Zapier, Integromat, etc. Would love to have integrations over the API that can update other apps based on when I modify something in Airtable.

Is there any update on the progress of this feature or any expansion of the beta? I am a pro plan user and this would be extremely useful for my member database and mobile app integration. Apologies if there is more info elsewhere in the forum. I’m new here.

tried to get to the form … it failed … very interested in testing this feature


Chris

tried to get to the form … it failed … very interested in testing this feature


Chris


Hi chrisboat and Nic_Darling,


Thanks so much for your enthusiasm for last modified time! Our beta has ended but you will be happy to know that we are preparing this feature for general release. Although I don’t have a timeline to share right now, keep an eye on What's new - Airtable!

Hi chrisboat and Nic_Darling,


Thanks so much for your enthusiasm for last modified time! Our beta has ended but you will be happy to know that we are preparing this feature for general release. Although I don’t have a timeline to share right now, keep an eye on What's new - Airtable!


Is there any way to subscribe to that View, so we get notified of new features?

Anybody know how to use LAST_MODIFIED_TIME value to figure out that a view is updated?


Is there a way to get all the views that a record belongs to?

@Katherine_Duh Any update on when this will be available? Seems like the beta closed 6 months ago.

Try adding your voice here: Last Modified Timestamp



Why did the “Last Modified Timestamp” topic that had so many requests is gone?


Why did the “Last Modified Timestamp” topic that had so many requests is gone?


It’s not gone; it was merged into another topic covering the same ground. As much as possible, we prefer to keep similar discussions consolidated into single topics. I will now merge this topic into that topic as well, to keep the forums tidy.


The last modified time beta is now closed as we are readying the feature for a general release.

Hi folks. The last modified time field and the LAST_MODIFIED_TIME() formula function are now available for all! You can learn more about it in this support article.



A couple of things you might want to know about these two new features:



  • If you only care about changes made to certain fields (e.g. just wanting to know when the value in a Status field has been modified), then you can set this specification in the field customization menu or when setting up the formula, e.g. , LAST_MODIFIED_TIME(Status,{Due Date}) .

  • Last modified time detects when a user makes modifications in a non-computed field. In other words, last modified time doesn’t detect changes that occur without user intervention in a computed field. (In many cases, if you’re trying to detect when the value of a formula changed, you can work around this by making another formula that includes the fields used in the original formula.)

  • Last modified time starts tracking from when the feature was enabled in your base—so, for most of you, that’ll be sometime last night (May 8 or 9, 2019).

  • Sometimes, the last modified time field/function will return a blank value. This is normal, and occurs either if A) the record was last modified before the feature was enabled (as described above) or 😎 if it’s a new blank record (since no users have yet made any modifications, none of the fields have any last modified times).

Hi folks. The last modified time field and the LAST_MODIFIED_TIME() formula function are now available for all! You can learn more about it in this support article.



A couple of things you might want to know about these two new features:



  • If you only care about changes made to certain fields (e.g. just wanting to know when the value in a Status field has been modified), then you can set this specification in the field customization menu or when setting up the formula, e.g. , LAST_MODIFIED_TIME(Status,{Due Date}) .

  • Last modified time detects when a user makes modifications in a non-computed field. In other words, last modified time doesn’t detect changes that occur without user intervention in a computed field. (In many cases, if you’re trying to detect when the value of a formula changed, you can work around this by making another formula that includes the fields used in the original formula.)

  • Last modified time starts tracking from when the feature was enabled in your base—so, for most of you, that’ll be sometime last night (May 8 or 9, 2019).

  • Sometimes, the last modified time field/function will return a blank value. This is normal, and occurs either if A) the record was last modified before the feature was enabled (as described above) or 😎 if it’s a new blank record (since no users have yet made any modifications, none of the fields have any last modified times).


Can you have formula that detects when a status changes to a certain data point


For example if update a status from “Assigned” to “In-Progress” it will update the LMD, but if i Update it from “Assigned” to “Closed” it would do nothing?


Thanks

Can you have formula that detects when a status changes to a certain data point


For example if update a status from “Assigned” to “In-Progress” it will update the LMD, but if i Update it from “Assigned” to “Closed” it would do nothing?


Thanks


Yes you can use an IF. But this means if the status changes from Assigned to In-Progress and then to Closed, you will lose the date which was when the status changed from Assigned to In-Progress.


This would’ve been great if we can keep the last modified date of when the status changed to a certain pre-defined value regardless of what other value is added after this.

Reply


Terms & Conditions