modification date

[Jean Findy Louis]

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]

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]

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]

Дата-время изменение записи отлично отображается в свойстве entry():

       lastModifiedTime
https://scripts.mementodatabase.com/script_api/entry/#properties-1

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

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]

Sure. It was just 2 lines of JavaScript. It can't get much smaller than that. 

To view this discussion visit https://groups.google.com/d/msgid/mementodatabase/cc2a098a-b51c-4ac0-a187-8ada9995ed1cn%40googlegroups.com.

[Mmm]

Речь только о том, что можно получить данные об обновлении без дополнительного поля, используя свойство записи.

Скрипт можно записать в одну строчку:

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

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

[Bill Crews]

Yes, of course. 

To view this discussion visit https://groups.google.com/d/msgid/mementodatabase/f98ebb22-c9a2-42ce-adc2-6cb2d6d49b4fn%40googlegroups.com.