Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 26, 2023 04:19 AM
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!
Solved! Go to Solution.
Jun 26, 2023 06:18 PM
Hi @KevinDax ,
I recently saw this video and I think it is exactly describing what you are trying to achieve.
Hope it helps
Jun 26, 2023 05:34 PM
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.
Jun 26, 2023 06:18 PM
Hi @KevinDax ,
I recently saw this video and I think it is exactly describing what you are trying to achieve.
Hope it helps
Jun 26, 2023 09:27 PM
thank you - I think this is a perfect solution for me !
Jan 23, 2024 12:25 PM
@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?