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.)
+1 For last modified field or webhooks. Is there a mailing list we can get on for specific feature updates?!? Much appreciated!
+1 It looks like the feature is in development? It’d be nice to at least hear what the progress has been.
+1 Would love to see the last modified feature as well.
+1 on last modified request!
Hello. I’d also like to see a Last Modified function, to tell me when a record or even a given field in a record was last modified. Similar to the extant CREATED_TIME() function.
We use Zapier’s “new record in view” trigger to build a MailChimp mailing list for upcoming events. Sometimes an email address changes. Ideally I would use the Last Modified function in a filter that shows me only those records where the email address has changed since the date of event-ticket purchase.
I gather from the thread here that this has been in progress for some time. Hope to see it rolled out soon.
Thank you.
+1M to make “lastModifiedTime” for each record along with “createdTime” that you have. Why it is being so hard to add this column in your schema? This is so basic feature to have. It would make help to integrate with your APIs. Don’t you store the last modified timestamp already in your persistence layer? All we are looking for is to expose it in the API response as well:
TEST_TABLE record: {“records”:{“id”:“recNtemt9W2GgTd3J”,“fields”:{“Name”:“test”,“Notes”:“Test 4\n”},“createdTime”:“2018-09-19T22:35:26.000Z”, “lastModifiedTime”: “Please_Provide_this_field__”}]}
This request has been open since 2015, I am surprised to see it has not yet been added to the APIs response over last 3 years. What is the underlying issue which is making it so hard to add this field? Can someone from Airtable team provide any insights on it?
Thanks in advance.
Joining the party. +1 for this feature.
Still no update?
We have more people adopting our Airtable solution for product information and this is more and more critical.
@Airtable_Support @Airtable_Team
Any updates on the progress of this feature? @Airtable_Team @Airtable_Support
+1 to last modified timestamps. Please! At the very least a progress update would be nice 
+1 to last-modified timestamps. This is an essential element for tracking information efficiently. Thank Airtable!
+1 … I like to imagine my reply will be the one that tips this over the edge after 3+ years.
I would pay for airtables if this where a feature
Any update here? it’s been 5 months… we need this feature as our zaps are breaking all the time when trying to add a timestamp.
Also, @alexanian already wrote the code… how hard is it to do this? https://github.com/alexanian/airtable-last-updated-hack
+1 Definitely a vital field to have for tracking purposes!
I am building a CRM for my nonprofit in Airtable and the MODIFIED_TIME() is SO NECESSARY. It is currently the only missing piece!!! Please please make this happen.
+1 Would love to see this in the near future.
I have been wondering if the below could be a way out until Airtable builds this much requested “last-updated” feature in the application :
Create a new Text column called “Hash Value” and a Function column called “IsSynced”
The function column will compute the hash value (which is basically a concatenation of all the other columns of the table) and compare it against the “Hash Value” column. If they are not equal, it will return “False”, else “True”
There will be a separate “cron job” running on an external server that will use the API and check for only records which are not synced (i.e. whose IsSynced column value is false).
It will then “process” those records, meaning whatever the business logic is required to handle “updated” records. If required, it can also update a “Last Modified” date-time column with the time stamp when the job is run (which means that if the cron job is run every minute, then the “last modified” value will be out of sync by maximum a minute. Finally it will compute the new hash value (which is basically a concatenation of all the other columns of the table) and update it in the “Hash Value” column (which will automatically result in the IsSynced column being set to True, until the next update on the row happens which would cause the IsSynced to again become false and get picked up by the above cron job again.
The advantage of the above process, is that marking of “updated” records will be directly done through airtable function column, thereby avoiding the need to download the entire table and cross referencing the values externally.
Only those records which are identified as “updated” will be dealt with externally using the API, which should solve most of the cases which require an “update” trigger that is currently missing.
I am a rather new user to Airtable and still learning around, so would be glad to hear feedback on if the above makes sense (or not)
Thanks!
Any update here? I’m reading through the older comments in this thread and it seems it has been 1.5 years now since this feature was first requested. They don’t seem to be interested :face_with_raised_eyebrow:
And can you guys make the formula editor window bigger??
I was wondering when that would appear — I noticed it pop up as a datetime function a while back, but not one that could ordinarily be accessed. :winking_face: Kudos to Emmett and the team!
I had the owner of our workspace apply for the Beta. What is the expected turn around on getting a response and having access granted for our base? I don’t want to have to keep asking him to check his email for a response.
We are trying to use airtable as a scrum tool, but we are debilitated by this particular feature, along with not being able to subscribe to certain field changes.
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.
You could add a Datetime field for the completion, and automate it easily with Zapier.
