Last modified time [SOLVED]

Thanks Emmet!

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

~ Tim

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?

Hi Stuart.

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

~ Tim

ok thanks for the reply @Tim_Dietrich

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

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

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

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

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.

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

I’m trying to build a full fledged CRM with Airtable.

One of the critical features I need is to be able to update a {Case Closed} field with a Date/Time/Stamp when the value in the {Case Status} field is changed to “Closed”.

Then the need to be able to calculate in hours/days the time from Case opening to Case closure.

Is this doable in the current version?

Could you have a Case Closed Date column and enter it manually?

for sure, I’d just like to make it occur programmatically if I were to roll this out to a services team

If you are using the api then you can still do it programmatically, but I definitely see why you would want a modified date if you are having your team work directly with the tables.

I want the agents using a custom form to work a Case, when the field “Status” is changed to Closed or Hold, then I want the Case Closed or Case On Hold field updated automatically

enlighten me on how to do this with their API

thanks

I’m not an expert either. So here is my attempt at an explanation.

I’ve created html forms that submit to php pages on my server and those pages do curl requests. You could make one of those curl requests POST a new case and the date would be automatic. Then when the case is updated you do a curl request PATCH and change the status column and the “modified date” column you’ve created. Do the same again when they use the html form to close the case.

Inside your base, in the HELP menu, you will find a link to API Docs.

agreed those methods will work, I was attempting to “contain” all forms, functions, triggers, events, etc. within the database, like FileMaker Pro vs. just using their tables to simply store the data posted from other technologies stitched together - which I think is their desired endgame to be “FMPro like” (but I could be wrong)

and thanks!

No, I agree that their should be an auto-updating “modified date” column. I’m just letting you know how to workaround this missing feature.

+1

I’m using the API to sync data with Google calendar and Google documents, and having a date/time modified field is necessary to make this happen. I know that Airtable knows the date/time a record was changed; can we get that exposed in the API?

Thanks.

Any progress on this? This seems like a critical database feature for collaboration, and it’s been over a few months. Please mark my vote for adding this feature.

I’d like to make a plea that a modified timestamp be made available in the API…like now. :slightly_smiling_face: Surely it’s available internally, and without it, true syncing over the API is not possible.

Please?

Thanks.

+1 we need a last modified timestamp.

I’m definitely a +1 on this one.
Andrew - any updates on when this would be released?

@Andrew any update on this?

I’d love to have a MODIFIED_TIME() as well, would be really helpful!