Last modified time


#182

+1 Definitely a vital field to have for tracking purposes!


#183

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.


#184

+1 Would love to see this in the near future.


#185

I have been wondering if the below could be a way out until Airtable builds this much requested “last-updated” feature in the application :

  1. Create a new Text column called “Hash Value” and a Function column called “IsSynced”

  2. 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”

  3. 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!


#186

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??


#187

Moving this discussion into the feature requests section.


#188

The last modified time beta is here! Please see the top post in this thread for further details.


#189

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. :wink: Kudos to Emmett and the team!


#190

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.


#191

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.


#192

You could add a Datetime field for the completion, and automate it easily with Zapier.


#193

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


#195

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


#196

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


#197

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


#198

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


#200

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.


#201

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.


#202

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.


#203

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

Chris