I am a retired (2019) software engineer with 47 years of practice and expertise in data base design and modeling. I was an early adopter with a desktop database application called Knowledge Manager (aka K-Man) on a two floppy based IBM PC One in 1984. I also was an early adopter of Microsoft Access 1.0. I always wanted to find / use an Open Source desktop database development application. Hence this application that implements a hyperlink, using a regular Text Box bound control/field/column and when Double-Click(ed), will render the filename for each file that has a System Preference registered application via “xdg-open filename” and launching this command via the system shell.
Being use to having the hyperlink functionality available in Microsoft Access, I started to research the LibreOffice community blog looking for possible answers. All that I was able to find were “snarky” remarks that it could be done but no examples. Hence this application example.
This example has been developed on a Linux Mint (LMDE) OS. It has only been designed and tested on Linux Mint. On other platforms, it is up to you to adapt it to make it work.
This example assumes that you can create a simple table and can use the “Form Wizard” to create a simple form.
Here are the files:
LibreOfficeBaseHyperlink.zip
Download the zip and unzip into a folder where you have read/write privileges and open the odb Base container. Please open and read the file ReadMeHyperLinkDoc.odt