Save date/time of record change

[KevinDax]

Hello,
I have a table. In the table there is a column named "Status" (single select field) with different selection possibilities. ("Property1", Property2",...).

In the table is another date/time field.

I want that when the status in "Property1" is changed, record the time of this change in the date field.

How do I do this?

Thanks!

[Sho]

Hello, @KevinDax 
Airtable has a very nice last modified time field.
It is possible to record the modification date of a field by specifying the field in the "Specific fields" setting of the "Las modified time" field.

[Elyes80 · Accepted solution]

Hi @KevinDax ,

I recently saw this video and I think it is exactly describing what you are trying to achieve.

Hope it helps

[KevinDax]

thank you - I think this is a perfect solution for me !

[steven24]

@KevinDax Are you able to see the formula? I tried using the exact same one that was shown in the Youtube video provided by Elyes80 but i cant seem to get it right. By chance can you share it?