Can i add a link to a pdf file in a LO Base form?

[davzeppelin]

greetings anyone, i’m trying to create a database where each entry also points to a pdf file (which is different for every individual form)

following some tutorials on youtube i already made the basic table and form with simple things: ID, first and last name and description, but i have found nothing about how to link external files

and another thing, is it possible to make something like a button in the form that starts adobe reader and displays the pdf file so that the user can open it from there? do i have to make a macro?

i know pretty much nothing about base, i started using it yesterday for this project. i don’t even know if what i’m trying to do is possible. if not, i welcome every alternative, different approach or different software

thanks in advance!!!

[jayArr]

Yes you can do this by having text field in your record table in your database.

In the text field store the text of the URL that points to your pdf file.

Use a form to display your table records.

Use an on click action (in your text field) to activate a macro to open your hyperlink which will automatically start up your pdf reader.

Try searching for hyperlink in this forum for more info. or google “LibreOffice Base hyperlinks” or take a look at my free application at www.secretarybird.info for examples of how to do this

[davzeppelin]

Thanks very much!!!

after searching hyperlinks as you suggested i ran into this page
https://bugs.documentfoundation.org/show_bug.cgi?id=51203&redirected_from=fdo
where i even found a macro that solves my problem, made by another user years ago.

too bad there’s still not a built-in functionality but at least i’m not stuck anymore

by the way, great looking website, i’m no poet but your app deserves credit for all the features it has