Last modified time [SOLVED]

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

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

any update on the modified time value?

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

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.

Any update on the last modified time?

Any updates? Would love to have last modified for an inventory sheet

It does not appear that this functionality made it into Airtable in the coming months. True?

db

Hi Matt, I would like to add that the modified date and the user who created a record would be VERY helpful to our team in order to streamline our workflow as well. We are loving AirTable so far, just need those two features to really make it great.

Any ETA on those features?

Much appreciated! Keep up on the great product!

Thanks!
Tiffany

Hey Matt - would be great to know when this workaround is coming. Thanks!!

Hey team - any updates?

Any ideas on how to edit the Created Date field? I was manually logging created dates until discovering the field today. I need to edit all of the rows prior to today with the correct “created date” but it seems the field can’t be edited.

Hi - are there any updates on when a Last Modified Date will be available. Or if there is a workaround to show the records that have been recently changed.

As far as I know, the field can’t be edited. Something I’ve used before is to create a ‘created override’ column — essentially the manually-logged dates you currently have — and a ‘created’ column. The last is a formula field with the following configuration:

IF({Override}!="",{Override},CREATED_TIME())

This allows you to pick up the internal created timestamp as a default but allows you to override it manually if necessary. Presumably, at some point in the future, after aging out the last record requiring the override, you can delete the override column and set {Created} to be a field of Created_Time type.

Agreed with all above, the lack of a last modified timestamp is preventing us from using Airtable on a company-wide scale.

Is there any news on when this might become available?

Hi! I like this discussion. Evaluating Airtable now. Came here figure out how to access “last modified” timestamp.

Writing to add my vote: I won’t invest in the platform at all, until I can see the modified timestamp for any field or record, and can trigger the API on update types that I specify.

Reading between the lines from the comments from the AT folks over the year or more of this thread, sounds like maybe neither of these is that easy, and it may be a while.

I’ll probably build apps in G Suite for now, and check back on Airtable in a year. This is a really nicely thought out RAD system! Thanks!

+1 - This feature would be very handy! One use case: I have a base of contacts. Some contacts have a status of “Loss of Contact” and then I have an Archive view to help me clean up the database from time to time. If I could easily track and see when a record was last modified, it would make cleaning up outdated records a cinch! I look forward to this feature.

I’d like to create a zapier to send email alerts to my team anytime a due date is changed. I believe the only way I could do this is by using modified_date in a formula. This is pretty much necessary in getting my team to move from Trello to Airtable. Do we have a projected date on this feature?

Hi @Amber_Stacey - we would also need the ability to have instant Zaps - with the current Zap setup you can only have a Zap run once on a record which wouldn’t be effective every time the date changed.

However, you may be able achieve something similar with timed Zaps (where you specify how often they run). I wrote a blog post about how to use this to send notifications and you may be able to modify it to suit:

Sending Notifications from Airtable

Hope this helps…

I would love to see how you are using airtable as full CRM (minus last modified field) !

+1 to date modified feature … Do you have any other idea how can when was the last update!?

+1 missing a last updated + webhook just makes the system unusable as a backend for large datasets. We’re now pulling the API for the entire dataset just to compare

Last Modified Timestamp is a must to compete with other database systems

Hi Looking for a “Last Modified” cell. Any work around?

I would love to see how you are using airtable as full CRM (minus last modified field) !

The easiest way is to create a new linked record to track important events, and then roll up the creation time of those linked records using a MAX(values) aggregation function.

For instance, if you are tracking the last tme an attempt was made to reach a client, your [client] table would contain a linked record field called {contacts}. Each [contact] record would track, say, type of contact (phone, email, IM, etc.), result (spoke with, left message), next step, and so on; it would also contain a Created Time field. With each contact attempt, you would create a new [contact] record documenting the attempt.

Meanwhile, in your [client] record, you would define a {Last Contact} field as a rollup of {contact::Created Time} using MAX(values) as your aggregate function. You can also easily, if slightly inelegantly, pull any detail you wish from that most-recent [contact ] record by creating a field in [contact] that performs a lookup on {client::Last Contact}. Any [contact] field you wished to surface to the [client] record would then use this field to detect the most-recent entry; for instance, you could create a {Latest Next Step} field with this formula:

IF({Created Time}={Last Contact},{Next Step},BLANK())

You could then use either a lookup or rollup field (depending on how you planned to use the result) to pull the data through to the [client] record.

Is it as easy as having a LAST_MODIFIED() function? No. Does it work? Yes.