I am trying to upload a document (either a writer or pdf) in base table or via the form. I have found the option/button in the design form option “browse” which seems suitable to upload the document however cannot see the uploaded document in the table or the form. The doc needs to appear in the table and in the form. In the table I added the column document and described it as object (not sure what the correct option is). Could someone help me please.
Hello,
Please include you specific LO version & database used. What is the intention - storage? ability to view in form? something else? Large documents?
I am using libreoffice 7 Base (the latest version). The intention is to attach a writer document in my database (ie a writer document or quotation per customer for example), I just need to be able to upload the document/pdf in the form version of the connected table. It is a maximum 2 pages writer or pdf document. Hope this answer the questions above
Hello,
Although the questions were not answered (LO 7 is general & Base is not a database; it is the front end to a database), will try to present an answer.
Even though your documents are small, there is no provision for other than a single image in a form and basically for images only. For display in the form, PDF is OK - Writer doc not OK.
Can be done with a small macro. The link to the document (actually any URL) is stored in the table. As the records are scrolled through, the URL is copied to a push button. When the button is pressed it opens the file. So a PDF or Writer document or internet URL will work as well as others.
For code & sample see this post → How to add hyperlink in table of Base?