LINKED DATABASE

[Červeňák Viktor]

Hi, I have two databases in Memento Database.

One is called EL DOD and the other PASPORT.

I require these two libraries to be linked as follows:

• When I create a new record in EL DOD, it is automatically copied to PASPORT.

• When I update an existing record in EL DOD (that has already been copied to PASPORT), it is also updated in PASPORT.

• When I update a record in PASPORT, it is also updated in EL DOD (the record was originally created in EL DOD and copied to PASPORT).

Both libraries contain identical fields (Field name / Field type):

• Photo documentation of the container / Image/File

• Delivery location / Text

• GPS / Location

• Delivery note number / Text

• Contact record number / Text

• Type / Dropdown list

• Status / Dropdown list

• Date of execution / Date

• Completed / Text

• Name / Text

• Street / Text

• Postal code / Text

• City / Text

• E-mail / Email

• Phone number / Text

• Container number / Text

• RFID / Barcode

• Container type / Dropdown list

• Waste type / Dropdown list

• Container number / Text

• RFID / Barcode

• Container type / Dropdown list

• Waste type / Dropdown list

• Container number / Text

• RFID / Barcode

• Container type / Dropdown list

• Waste type / Dropdown list

• Container number / Text

• RFID / Barcode

• Container type / Dropdown list

• Waste type / Dropdown list

I have the fields Container number, RFID, Container type, and Waste type repeated four times, and it must remain that way.

Could someone please help me with a script as well, including step-by-step instructions on where and how to insert it, along with the script itself?  

Many thanks!

[Er Mo]

Hallo

Wie ich das Sehe hast du 2 Bibliotheken mit den Selben Inhalt . Wieso brauchst du 2 Mal das Selbe ? Das kopieren mtites Skripte ist möglich , aber es können leicht " Konflikte " auftreten und zu Datenverlust führen

Hello
As I see it, you have two libraries with the same content. Why do you need the same thing twice? Copying with scripts is possible, but conflicts can easily arise and lead to data loss.

Ernst

[Červeňák Viktor]

Hello.

So if there were separate fields, how would you do that?

I require these two libraries to be linked as follows:

When I create a new record in EL DOD, it is automatically copied to PASPORT.

When I update an existing record in EL DOD (that has already been copied to PASPORT), it is also updated in PASPORT.

When I update a record in PASPORT, it is also updated in EL DOD (the record was originally created in EL DOD and copied to PASPORT)

Could you please help me with a script as well, including step-by-step instructions on where and how to insert it, along with the script itself?  

Thanks.

Dátum: piatok 22. augusta 2025, čas: 18:19:02 UTC+2, odosielateľ: ernst...@gmail.com

[Bill Crews]

Still, why 2 fields? How do you plan to use them? In 2 distinct use cases? No summarization (roll-up) of one to the other? Is the 2nd one intended to be entries kept for historical purposes, archival, or backup? Why not just one? 

--
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 visit https://groups.google.com/d/msgid/mementodatabase/180adf14-0743-40ef-8755-1020524857d9n%40googlegroups.com.

[Er Mo]

Hallo

Um das richtig zu verstehen . Du hast 2 Bibliotheken ( EL DOD, PASPORT ) und du möchte das diese immer gleich sind . Egal wo du was änderst , es soll auch in der anderen Bibliothek geändert sein . Also 2 GLEICHE Bibliotheken . Wieso verwendest du dann nicht einfach nur 1 Bibliothek . Oder möchtes du 2 Felder die in 2 VERSCHIEDENEN Bibliotheken mit unterschitlichen anderen Felder sind , gleich halten . Dafür würde ich eine 3 Bibliothek verwenden in der die 2 Felder sind und diese auf die 2 Bibliotheken  ( EL DOD, PASPORT ) mit den Feldtyp " Verknüpfung zum Eintrag " verlinken . So wirkt sich jede änderung auf alle Einträge aus .

Hello
To understand this correctly, you have two libraries (EL DOD, PASPORT) and you want them to always be the same. No matter where you change something, it should also be changed in the other library. So, two identical libraries. Why don't you just use one library? Or do you want to keep two fields that are in two different libraries with different fields the same? For this, I would use a third library containing the two fields and link them to the two libraries (EL DOD, PASPORT) with the field type "Link to Entry." This way, every change affects all entries.

Ernst

[Červeňák Viktor]

The fix has been made. I have changed it to different field names. The point is that one is for the crew who has restrictions on it and for keeping track of where everything is. I know it can be done differently but please at least make me a script where I just write the field names. + I also have date, photo, selection list, signature fields. I remind you what I actually want:

When I create a new record in EL DOD, it is automatically copied to PASPORT.

When I update an existing record in EL DOD (that has already been copied to PASPORT), it is also updated in PASPORT.

When I update a record in PASPORT, it is also updated in EL DOD (the record was originally created in EL DOD and copied to PASPORT)

Thank you very much.

Dátum: sobota 23. augusta 2025, čas: 21:04:24 UTC+2, odosielateľ: ernst...@gmail.com

[Er Mo]

Hallo
Das ist nicht so einfach . Du hast " Normale " Daten ( Text , Zahlen ,. ) und Datum ( Wird anders als Zahlen behandelt ) und Bilder ( Unterschrift ist auch ein Bild ) . Auch muss man den Datensatz einteutig erkennen können um ihn zu ändern . Das ist etwas komplezer als " Nur " kopieren .

Es gib auch die möglichkeit Felder für einzelne User unsichtbar zu machen . Es können ganze Unterortner ausgeblentet werden .

Hello
It's not that simple. You have "normal" data (text, numbers, etc.) and dates (treated differently than numbers), and images (signatures are also images). You also have to be able to clearly identify the record to change it. This is a bit more complex than "just" copying.

There's also the option to make fields invisible for individual users. Entire subfolders can be hidden.

Ernst