Date/time field type that automatically updates to current date/time when a record is saved.
I have a database of places I visit on an irregular basis, it contains for example where to park or where to eat. Some times I don't visit a place for a long time a year or more and the information changes. There is no easy way to know how old the data in a particular record is. The normal date/time field needs to be manually updated if you edit a record, the chances are that edit won't happen... Could be an extension to the automatic "current date" requested for date calculations.
There is a Trigger script example "Beginning of the next day" in the Memento Wiki. Based on that I wrote a Trigger script that triggers upon "Updating an Entry", "After saving the entry" that gives a value to a date field that I created, called "Modified". The script reads as follows:
This uses the "moment.min.js" library, which I had to attach.
I expect it would work with a Date/Time field as well.
J. Clarke commented
Still no clue ?
A last modified and last viewed entry would be nice.
Asked for again in January 15: https://memento.uservoice.com/forums/110673-general/suggestions/7018495-modified-date-and-time-in-database-memento this has 4 votes.
We now have the now() function but that is set when a record is opened not just when it is opened for editing and saved.