Need dates added automatically when job number is entered

48 views
Skip to first unread message

Joanna Tolson

unread,
Sep 23, 2025, 1:31:18 PM (11 days ago) Sep 23
to mementodatabase
I am new to MementoDB (desk top version on MacBook Air) and I am building a database of cosmetics purchased. What I'd like to happen is when I enter an Order Number, the fields for Date Ordered and Date Delivered are automatically filled with the dates associates with that specific Order Number after I enter those dates on the first item.

Please keep in mind that I am new and not familiar with Javascript or the Triggers/Automation options so explain it to me like a 5-year old. 

Appreciate any help I get. 

Er Mo

unread,
Sep 23, 2025, 2:25:17 PM (11 days ago) Sep 23
to mementodatabase
Hallo
Von wo kommen die Daten die Automatisch ausgefüllt werden sollen .Sind die daten in einer andern Bibliothek oder sollen die Daten von Vorigen Eintrag kommen . Bei Datum kann man das " Heutige " Datum voreinstellen . Das auch Überschriben werden kann .

Hello
Where does the data that should be automatically filled in come from? Is the data in another library, or should the data come from a previous entry? For the date, you can preset "today's" date. This can also be overwritten.

Ernst

Joanna Tolson

unread,
Sep 23, 2025, 3:38:08 PM (11 days ago) Sep 23
to mementodatabase
Danke Ernst - I would like the data to come from the previous entry. I am currently entering past orders to the database so I need to enter dates before "today"s date. I could copy and paste, but I am already using that to enter the order number.

Er Mo

unread,
Sep 23, 2025, 4:27:50 PM (11 days ago) Sep 23
to mementodatabase
Hallo
Mit hilfe von einem Skript kann man die Daten von " Vorigen " Eintrag holen und in die Felder schreiben bevor das Fenster geöffnet wird . Das heist das in den Felder die Daten von den zuvor eingegebenen Datensat stehen . Diese können dann Überschriben werden wenn sie nicht mehr stimmen .

Hello
With the help of a script, you can retrieve the data from the "previous" entry and enter it into the fields before the window opens. This means that the fields will contain the data from the previously entered data set. This can then be overwritten if it is no longer correct.

Ernst
Reply all
Reply to author
Forward
0 new messages