Skip to main content
Solved

Save date/time of record change

  • June 26, 2023
  • 4 replies
  • 42 views

KevinDax
Forum|alt.badge.img+6

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

4 replies

Forum|alt.badge.img+21
  • Inspiring
  • 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
  • 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


KevinDax
Forum|alt.badge.img+6
  • Author
  • New Participant
  • 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


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


Forum|alt.badge.img+1
  • New Participant
  • January 23, 2024

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?