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.
Dave
shared this idea
-
Wehmann5
commented
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:
var m=moment();
entry().set('Modified',m.toDate().getTime());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
I had a work around working up until the last update (4.7.3). Now it will only show as a text field. moment().format('LLL'); used to work with JavaScript, now forces it to text that can't be a date.
-
Riki
commented
Still no clue ?
-
mohaynes
commented
A last modified and last viewed entry would be nice.
-
Dave
commented
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.