modification date

109 views
Skip to first unread message

Jean Findy Louis

unread,
Apr 25, 2024, 9:08:30 AM4/25/24
to mementodatabase
Is it possible to display in a field the modification date of each database entry?  The name of this field will be called "update".


 thank you for helping me

Bill Crews

unread,
Apr 25, 2024, 4:59:49 PM4/25/24
to Jean Findy Louis, mementodatabase
Create a trigger for Creating an entry and another for Updating an entry. Use this script for each trigger...

let e = entry();
e.set("update", e.lastModifiedTime);

On Thu, Apr 25, 2024, 9:08 AM Jean Findy Louis <jnf...@gmail.com> wrote:
Is it possible to display in a field the modification date of each database entry?  The name of this field will be called "update".


 thank you for helping me

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/d3616395-97e7-4657-9858-f37508b16c1bn%40googlegroups.com.

Alberto Pignocchino

unread,
Mar 10, 2026, 1:21:25 PM (7 days ago) Mar 10
to mementodatabase
I would like to remind everyone that, for Creation date column only,
  selecting as default value: "current date by default" seems enough.
For Update date column, I've tried but not been able to find a trigger solution not using JavaScript
 (may need a suitable verb grammar for the macro language in the help, not found at the moment).
Thanks anyway to @BillCrews for the JavaScript solution.

Mmm

unread,
Mar 10, 2026, 2:29:50 PM (7 days ago) Mar 10
to mementodatabase
Дата-время изменение записи отлично отображается в свойстве entry():

Для изменения этого времени скрипом достаточно присвоить практически любому полю его текущее значение.

let e = entry();
let data = e.field('field name'); //любое числовое, текстовое, логическое, ... поле (проверяйте)
e.set('field name', data);

вторник, 10 марта 2026 г. в 20:21:25 UTC+3, a.pign...@gmail.com:

Bill Crews

unread,
Mar 10, 2026, 5:11:04 PM (7 days ago) Mar 10
to Alberto Pignocchino, mementodatabase
Sure. It was just 2 lines of JavaScript. It can't get much smaller than that. 


Mmm

unread,
Mar 10, 2026, 5:32:28 PM (7 days ago) Mar 10
to mementodatabase
Речь только о том, что можно получить данные об обновлении без дополнительного поля, используя свойство записи.
Скрипт можно записать в одну строчку:

entry().set('field name',  entry().field('field name'));

среда, 11 марта 2026 г. в 00:11:04 UTC+3, bill....@gmail.com:

Bill Crews

unread,
Mar 10, 2026, 6:57:23 PM (7 days ago) Mar 10
to Mmm, mementodatabase
Reply all
Reply to author
Forward
0 new messages