LibreOffice Base (10) Filter and Background

An introduction to the filter on the navitgation toolbar, how to change the background and adding a logo to your form.
The downloads to go with this series can be found here:
thefrugalcompu...

[@dimjim2365]

I absolutely love your tutorials. I first started viewing them jumping around to resolve an issue for my wife at work dealing with exporting and importing spreadsheet data and getting it into a database. I got the basic requirements accomplished but your tutorials are so informative that I aspired to make a better product. Now I am viewing them in order to REALLY find out how to use it and apply it for a relational db. Thank you very much for superior training material. I am definitely going to pass your channel on to my friends.

[@lenatlenshamn]

Very well done set of tutorials. Thanks much for your excellent efforts. As a developer of instructional materials, I can appreciate the effort you have put into this project. Keep up the good work!

[@axelec]

Thank You... LibreOffice needs to thank you

[@robitops1547]

I was confused how form filter use, Not I got it,
Thanks again.

[@ChampionChapters]

Thank you! I love your tutorials!

[@joelgarciadacosta6215]

Excelent!

[@gooon666]

Thank You for your tutorials. When I click on the Form Based Filters icon, the Filter Navigator window popped up only once, and I hardly worked on it. Now, that window isnt opening at all despite several attempts. Could you tell me whats wrong and how to open the Filter Navigator window? Thank You.

[@dhakprasadupreti6249]

Good

[@HawkThePhoenix]

Could you put pictures into the database and have a picture associated with each employee pop up this way?

[@TechN9ne0852]

I've also been wanting to know this. Did you ever find an answer for this?

[@HawkThePhoenix]

@@TechN9ne0852 Not yet

[@TechN9ne0852]

@@HawkThePhoenix damn. Thanks for the reply

[@8603k]

how to set filter by part of string, i need to filter only names which include "iva" in themselves, like "ivan"

[@gregoryjee]

Thank you so much for your amazing videos! They've been extremely helpful! I have a question. What if you have an employee who works in multiple departments? Is there a way to list more than one department in the "Department" section and still be able to find that person in the filter? I'm trying to find a way to search for keywords in different sections without it having to be exactly what's in the text box. And what if you have an employee who works in three different departments and you want to find everyone who works in either of two departments, including the two that this person works in?
I guess my main questions are: Can you have multiple text entries in one box and can you filter without typing everything that's in the box

[@MichaelsTechTutorials]

see videos 63, 64, and 65 about Junction Tables for that issue - th-cam.com/video/JsN3lwvHjzs/w-d-xo.html

[@gregoryjee]

thanks!

[@bhagyashreeingle1501]

I want to know how will you apply filter for the phone drop-down box so that it should only show those phone nos. which are related to the name selected in name drop-down box of employee form.

[@MichaelsTechTutorials]

I think what you are trying to do is explained in video 36 th-cam.com/video/x7i6Z1RIkAw/w-d-xo.html Note, these videos go in order - so, if you skip right to video 36, you may be skipping some important explanations needed for that video.

[@bhagyashreeingle1501]

Thanks a lot for this video. It was helpful. But I have query. Lets say, in your employee form you have 2 drop-down box. One for First name of the employee and another for the phone no. So next time when you want to know the phone no of a employee and every employee have 2-3 phone no. to contact. If you select his name from the Name drop-down box then in the phone no. drop-down is it possible to get only those 2-3 phone no. which are entered in his form .

[@bhagyashreeingle1501]

Thanks for the reply. What if, you don't want to add sub-form in your main form employee. You just want to add field phone no. and then if you have drop down for your phone no. and first name field. I want to know without adding sub-form how will you synchronize these two drop down boxes. In employee form, if I select from the first name drop down a name of a employee then if i click on drop down of phone no. I want it to show only phone nos. which are related to that particular employee which I have selected in first name.

[@MichaelsTechTutorials]

Check out video 54, you would need to do the same thing as that, but your subform would be a listbox drop down, instead of a table control. This video is updated by a button, you could control that with a macro, but macros are not covered in this video tutorial series.