LibreOffice Base Tutorial (Making a Filter Inside a Form)

Introduction: 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 (Video 55,56,57)

Teacher Notes

Teachers! Did you use this instructable in your classroom?
Add a Teacher Note to share how you incorporated it into your lesson.

Be the First to Share


    • Backyard Contest

      Backyard Contest
    • Silly Hats Speed Challenge

      Silly Hats Speed Challenge
    • Arduino Contest 2020

      Arduino Contest 2020

    4 Discussions


    5 years ago on Introduction

    Thank you for your tutorial, good to learn from it. I have a question. I am working on a database with materials. So I made check boxes for the materials. And I want to check multiple materials for one search, and I want those materials to end up in the table material with a comma in-between. So be clear: I check cotton, hemp and soy. Then I want the table material to say: cotton, hemp, soy and I want all the factories that have one of these 3 materials to be listed (so it could also be that it only says cotton). I added all the data in a table as you can see in the second picture per material. So factory 1 has none of those materials as they are all false. (the list goes further on then silk, with other materials) but the 16th Factory has Nettle. Do you know how I can do this?

    Screen Shot 2014-12-05 at 11.36.42.pngScreen Shot 2014-12-05 at 11.39.18.png

    Reply 5 years ago on Introduction

    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.