Hi, I tried logging this on Nabble, but was told that was the wrong place and should report it as an issue. Please can a hyperlink field type be added onto Base? Thanks Peter Jones
Created attachment 63950 [details] Open any file in Base with the program, which is connected to the filetype
Have added a database (without any table) to show who it works now: You could use a normal textfield or a field with a mask. The hyperlink must be placed in this field. You could press the button "Anzeigen" and the page will be shown with your browser. Works also with all other formats in your system, which are linked to the extension of the file. For this funktion you have to enable the makro-functionality in LO. Have changed the importance to "enhancement". Robert
Changed the Importance to "enhancement" and Status to "needinfo".
Created attachment 63980 [details] Try form "Mail_Websiteaufruf_direkt" - behaviour like hyperlink Little database for more functions. I remembered, that I had created a textfield with blue underlining and hand-cursor. When there is noting inside the textfield you can klick it with the mouse - nothing happens. When you write an adress without "http://" it opens the webbrowser and starts this address. Activate macros for these functions.
(In reply to comment #3) > Changed the Importance to "enhancement" and Status to "needinfo". Hi Robert, What information is needed?
I agree, I can not understand what extra info is needed. I made the original post, and whilst I appreciate the work around, I would just like a field type of 'Hyperlink' which works in the same fashion as MS Access. Best wishes Peter
Did you have tested the attachment "Mail Websiteaufruf direkt"? Is this the function you need? I don't know anything about field-types in MS Access. But the field in my attachment looks like a link and works like a link. Certainly it isn't a original field-type of Base, because it works with a macro. You must know there are many people who don't work with MS Access and many databases, which haven't a field-type "hyperlink". They only work with a text-field. Could be MS Access works with a database, which also saves it only in a text-field and works with it like my attachment, programmed original in the GUI. Robert
Thanks for the update. This does work, but it is a workaround rather that a solution. If you search on Google for OpenOffice / LibreOffice Base Hyperlink Fields you will see lots of people have wanted this for many years as an additional field type. I enclose a request which goes back as far as 2008: http://user.services.openoffice.org/en/forum/viewtopic.php?f=61&t=3792 People want to move their databases and get rid of Microsoft software on their machines, but modern day databases need an easy way of handling hyperlinks as field types. For example, I have a database for my online banking in access, and for each institution I have: ID Bank Name Bank Address Telephone Website Address It just makes life easier. Please see below for the Access field types. http://office.microsoft.com/en-us/access-help/field-data-types-available-in-access-mdb-HP005238518.aspx Sorry if this sounds like a rant (It is not supposed to), I just spend much of my time trying to convert people to Open Source, and regardless of if we like it or not, we have to compete with Microsoft Office. It seems that Base is always the last product to get the updates. Best wishes and I really do appreciate the work the Libre Office team are doing. Peter Jones
I have changed it to NEW, because it hasn't been closed. I have set this to NEEDINFO, because I wanted to be informed if the attachment https://bugs.freedesktop.org/attachment.cgi?id=63980 shows the right behaviour. So we will hope there is someone, who could change the fields in the forms of Base for this behaviour. A field like a hyperlinkfield doesn't exist in the internal HSQLDB. But when it works in forms it will be the best solution for all databases, to which Base would be linked. Robert
I wish to add my support to Peter Jones's request. This is an important enhancement that would make Base so much more user friendly. I personally would like to see the functionality to mimic that of LO Writer. The user adds a large text field to his table in Base, perhaps called "comments", and in the form he can then add some text and also insert hyperlinks by pressing Insert > Hyperlink, the exact same dialog box as in Writer. The result would be a hyperlink in blue and underlined in the "comments" field of his form that can be opened with ctrl and right click. No macros, no Python, all designed with the user interface.
(In reply to comment #6) > I would just like a field type of 'Hyperlink' which works in the > same fashion as MS Access. This is just for information. The Microsoft Access Hyperlink data type is based on the Microsoft Jet Memo data type i.e., it is a proprietary / non-standard modification. Jet is the database engine used in Access. SQL Server has no equivalent of this data type. HSQLDB (v1.8 or v2.3) and Firebird do not have a Hyperlink data type either. The reason why these databases do not have this type is likely because they rely on an SQL specification (e.g., ISO/IEC 9075-2:2008) to determine valid data types. Examining the Final Committee Draft (FCD) for the 2011 version of the SQL specification, indicates this updated version still does not define a Hyperlink data type. Similarly, ODF v1.2, Part 1, §19.42 (p. 344) defines the db:data-type attribute as being defined by ISO/IEC 9075-2:2008 and gives this example: > The values of the db:data-type attribute are bit, boolean, tinyint, smallint, > integer, bigint, float, real, double, numeric, decimal, char, varchar, > longvarchar, date, time, timestmp, binary, varbinary, longvarbinary, sqlnull, > other, object, distinct, struct, array, blob, clob or ref. While I can see the value of having a Hyperlink data type, it would appear to depend on one of these options: 1. Changing ISO/IEC 9075-2 (unlikely). 2. Changing ODF to support a non-standard data type (also unlikely). 3. Changing ODF to include a further data attribute indicating special treatment of a VARCHAR data type (possible, but requiring an OASIS issue to be raised). 4. Some sort of hard-coded implementation in Base for special treatment of a VARCHAR data type (possible, but maybe undesirable). Option (3) would seem most likely IMO.
Adding self to CC if not already on
*** Bug 97565 has been marked as a duplicate of this bug. ***
*** Bug 151125 has been marked as a duplicate of this bug. ***
(In reply to Alex Thurgood from comment #14) > *** Bug 151125 has been marked as a duplicate of this bug. *** Hi @Alex: you said it, "4. Some sort of hard-coded implementation in Base for special treatment of a VARCHAR data type" Option (3) would seem most likely IMO. I still do not get, where the problem lays: Any text-field can hold the URL, there is no need for an extra data-type, the function must be part of the forms, in which the control of this field has the property of being a control of type Hyperlink, absolutly similar to the behavior of hyperlinks in word or calc. so, what is the problem? martin
(In reply to mhonline from comment #15) > > I still do not get, where the problem lays: Any text-field can hold the URL, > there is no need for an extra data-type, the function must be part of the > forms, in which the control of this field has the property of being a > control of type Hyperlink, absolutly similar to the behavior of hyperlinks > in word or calc. > so, what is the problem? > The problem is that there are no database devs with time, knowledge and interest to work on such a solution.
Is there any update on this Alan? I was the one who originally logged this in 2012! I'm trying to be constructive here, but the LibreOffice project makes a huge play on being an opensource alternative to Microsoft Office and how it's supposed to ' unleash your creativity and enhance your productivity', but the truth is apparently 'no developers have interest to work on such a solution.' I'm still holding out hope that I and many others can move to LibreOffice. You have made great enhancements to the other apps, but Base always seems the poor relation. Please feel free to contact me directly about this.