LOBase - Hyperlinks in Tables

users
#1

Hi,
   I am very comfortable with most aspects of LO except Base. I am now
starting to use this option and I find it rather daunting compared to MS
Access (simply because I have used this for years). I am busy with my first
table design and I would like to create two fields as hyperlinks to
external files. One of these is an audio file and the other is an LO Writer
file. In Access there is an option to set the field type as "Hyperlink" but
I do not see anything like this in Base. Is it possible to create such a
field and could someone please point me to where I could find instructions
on how to do so?
  I am also a little old fashioned and prefer to have a hard-copy manual by
my side but if it has to be electronic then it should at least resemble a
book. Because of this I find the Help file in LO (modern MS the same)
rather awkward to use.

Thanks,

Paddy

#2

Hi :slight_smile:
Errr, i'm not an expert in Base btw. I implied that in my last post but it
is not so.

Regards from
Tom :slight_smile:

#3

Hi :slight_smile:
Published Guides are at;
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook
At the bottom of each book is a link for purchasing a paper-back copy from
Lulu Bookstores = or print the whole book or relevant chapters for 'free'
(errr, excluding costs of paper& toner/ink)

An on-line Faq is here;
https://wiki.documentfoundation.org/Faq

There is also a section in the Apache OpenOffice forums about Base;
https://forum.openoffice.org/en/forum/viewforum.php?f=13&sid=bbc23542840135936c07d2693c3541d7

The LibreOffice "Ask LO bot" is at
http://ask.libreoffice.org/en/questions/

I hope this helps! You can also ask questions here. There are some
experts here but lately we have been a bit slow to answer.
Regards from
Tom :slight_smile:

#4

Hi Pat,

I do not see anything like this in Base. Is it possible to create such a
field and could someone please point me to where I could find instructions
on how to do so?

1) There is no such thing in LO Base as a default clickable URL field
definition option.

2) If you want similar functionality to what Access provides with regard
to clickable URLs, you have to program it via macros, and use the
VARCHAR_IGNORECASE field type.

An example of taking a character string pointing to a file and opening
it with another application (in the case below, a PDF) :

https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=4778&p=29999#p25810

Alex

#5

Thanks Alex,
   I had not planned on getting into macros just yet but maybe this is as
good a time as any. I will work on it and see how far I get.

Paddy

#6

Hi :slight_smile:
There is an excellent macros guide at
https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers
Regards from
Tom :slight_smile: