Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Save date/time of record change

Solved
Jump to Solution
1922 4
cancel
Showing results for 
Search instead for 
Did you mean: 
KevinDax
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Solution

Accepted Solutions
Elyes80
6 - Interface Innovator
6 - Interface Innovator

Hi @KevinDax ,

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

Hope it helps

See Solution in Thread

4 Replies 4
Sho
11 - Venus
11 - Venus

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
6 - Interface Innovator
6 - Interface Innovator

Hi @KevinDax ,

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

Hope it helps

KevinDax
5 - Automation Enthusiast
5 - Automation Enthusiast

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?