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
10 - Mercury
10 - Mercury

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

218 Comments
Elias_Gomez_Sai
13 - Mars
13 - Mars

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

PageMonk
6 - Interface Innovator
6 - Interface Innovator

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?

Candice_Garcia
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Daniel_Farina1
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Katherine_Duh
10 - Mercury
10 - Mercury

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.

Katherine_Duh
10 - Mercury
10 - Mercury

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.

modifying.gif

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 B) if it’s a new blank record (since no users have yet made any modifications, none of the fields have any last modified times).
Garrett_HUssey
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Goce_Ristov
6 - Interface Innovator
6 - Interface Innovator

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.