Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Save date/time of record change

Solved
Jump to Solution
1389 2
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?