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

Thanks Emmet!

This will really help when using the API, especially when caching and/or syncing is involved.

~ Tim

Stuart_Brameld
6 - Interface Innovator
6 - Interface Innovator

just been looking for this, would be really useful to have a last modified time.

I’ve seen the creation timestamp exists now but not sure a last modified timestamp exists yet? @Tim_Dietrich?

Tim_Dietrich
6 - Interface Innovator
6 - Interface Innovator

Hi Stuart.

No, we don’t have a modified timestamp… yet.

~ Tim

Stuart_Brameld
6 - Interface Innovator
6 - Interface Innovator

ok thanks for the reply @Tim_Dietrich

Aaron_Owen
7 - App Architect
7 - App Architect

I’d like to add a plus one for a date modified function.

Stuart_Brameld
6 - Interface Innovator
6 - Interface Innovator

agreed, last modified would be extremely useful. I’d like it a the row level i.e. when was this row last modified

Andrew
6 - Interface Innovator
6 - Interface Innovator

Created and modified date fields are coming soon! In the meantime, you can actually use a formula column to get the created time:

0de14978642fa9efa55ccfcfb84758afed32ded8.png

Aaron_Owen
7 - App Architect
7 - App Architect

I’ve done that, but then filtering by date specific criteria i.e.: today / yesterday isn’t available.

Aaron_Owen
7 - App Architect
7 - App Architect

Something related to this the ability to capture who has done an action. I have table that contains work orders, and I’d like to auto-populate a field that captures who has created the work order (which is actually a field linked to the people table). It’s related to date created and date modified, but should be it’s own thing.

Kai_Lindemann
4 - Data Explorer
4 - Data Explorer

Hi Andrew, any update on this?

It’s an absolute killer-feature that would make us use airtable for much bigger projects in our company than we do right now. We are desperately waiting for a last-changed field.

Best,
Kai