LibreOffice Base Tutorial (Making a Filter Inside a Form)

by mjm2008

12K34

Intro: LibreOffice Base Tutorial (Making a Filter Inside a Form)

In this Tutorial, I make a new database using LibreOffice Base and I try to make a filter form using an external SQL Query.

Using text box, or combo box as parameter for searching for items in records, is not easy in LibreOffice. In this tutorial I show you how to do it.

In LibreOffice Base, you cannot copy or paste data from table-object inside a form if the data-input for the objects comes from an embedded SQL query inside the form itself.

So, to solve this problem, you need to make an external SQL.

This tutorial is based on the original tutorial that you find it here

https://www.youtube.com/user/TheFrugalComputerGuy (Video 55,56,57)

3 Comments

bobtestgr 4 years ago

Thank you for your tutorial

mjm2008 9 years ago

Hi, thank you for your comment.

As I did, you make the filter using a separate table for search purpose only. and if you look at all videos I have on Youtube, you will understand how to combine several items together. You can add several columns and make them to be collected and summed in one column in the SQL Query.

The result will not be a table, it will be a SQL query. From that you can show your data in a table-object.

Please try to see the videos I have and download the database files, I hope you understand how I did them.

seamster 9 years ago

Interesting, thanks for sharing.