Skip to main content
Solved

Save date/time of record change


Forum|alt.badge.img+4

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!

Best answer by Elyes80

Hi @KevinDax ,

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

Hope it helps

View original
Did this topic help you find an answer to your question?

4 replies

Forum|alt.badge.img+19
  • Inspiring
  • 560 replies
  • June 27, 2023

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
Forum|alt.badge.img+6
  • Inspiring
  • 18 replies
  • Answer
  • June 27, 2023

Hi @KevinDax ,

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

Hope it helps


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 3 replies
  • June 27, 2023
Elyes80 wrote:

Hi @KevinDax ,

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

Hope it helps


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


Forum|alt.badge.img+1
  • New Participant
  • 1 reply
  • January 23, 2024
KevinDax wrote:

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


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


Reply