1vote

Would it be possible to save in a field the date when another field was last modified?

Asked Apr 2, 2022

6669 Views
1 Answers
Solved

Let's say that a field yesterday was changed from "to do" to "in progress"; would it be possible to automatically save in another field the date of the status change, i.e. "yesterday"?

asked Apr 2, 2022 by emilec___ (370 points)

1 Answer

1vote

polle Points102630

This already comes with Notion. :)

Just create a new column (property) and from Type select "Last edited time".

That will show you the date and time from the latest edit.

answered Apr 3, 2022 by polle (103k points)

selected Apr 8, 2022 by emilec___

1vote

emilec___ commented Apr 3, 2022

Thanks Polle for the reply :)

And would it also be possible to link this "Last edited time" to the change of a specific field in a table? Or to get this information some other way.. As far as I understand, now "Last edited time" updates whenever something changes on a certain page (e.g. in a row of a table).

For my use case, I would need a tag that tells me when only a specific field on a page changes, for example to detect the select field "status" changes from "todo" to "approved".

It's a bit more complicated, but I think it would be of immense value if this could be easily implemented to automate many processes.

An ideal application would be "if the status of a specific field changed from todo on ongoing more than 2 days ago, then send me a Notion reminder".

And thank you!

commented Apr 3, 2022 by emilec___ (370 points)

1vote

polle commented Apr 4, 2022

It is possible, but that is a completely different question. Please mark this one as solved and feel free to open as many new ones as you need. :)

commented Apr 4, 2022 by polle (103k points)

1vote

emilec___ commented Apr 8, 2022

Great, looking forward to knowing how. And thank you!

commented Apr 8, 2022 by emilec___ (370 points)

Please log in or register to answer this question.

...

Would it be possible to save in a field the date when another field was last modified?

Please log in or register to add a comment.