If you want to get up and running with useful forms real quick, watch this video, I take you through how to create a sub-grid that's dependent on the main grid, If you've any questions on this post them below.
Having cut my teeth on MS Access I found it quite hard to swith to Libre Office. This tutorial is quite simply the cleares and simplest explanation of forms and sub-forms. Thank you. It has aved me hours of wading through forum posts.
Exactly I have just been commissioned to build a database in libreoffice connecting to mysql and this video has done the same for me. Wading through messy data rich forums is just too painful. Thank you Sean You have got another subscriver
Thanks! I now have a better understanding of the relationship between Form/Sub Form. Long time Access/VB programmer which has been both a help and quite in hindrance in LibreOffice.
Thank you Sean. Now I understand how subforms match records. I see now that I can even nest multiple datasources and manage their relationships with their nesting structure and setting the appropriate match fields
Yes, it's fairly powerful isn't it? Right now I'm looking at creating some tutorials that combine LibreOffice with MySql, that could be interesting....
Thanks, I now have a better understanding of the form/sub form function. Long time Access/VB programmer and that has both helped me and hindered me in LibreOffice.
Thank you Sean for your very clear explanation on how to create data selection forms! I currently have it work on my own address database with one data selector, now I'm gonna try to figure out if I can filter on multiple selectors at once, like country/city/type of company etc. I subbed to your channel and gonna browse through your videos.
Thanks for an informative and easy to follow video. Having just opened Base yesterday, I feel I'm gaining foot hold in the app. I come from a programming background - but still, for my own needs (I run a my own company) I feel that rapid and prototyping tools are many times sufficient.
A short comment on names used to link the connection between parent/child forms: for me the names used to identify those columns are the ones I use in the SQL queries - not the ones used in UI properties (labels, names).
Hi @Sean Johnson, thanks for the series, awesome videos. Is there any way you could expand this a bit in a way that you show how to add a button to this existing form that, when pressed, creates and shows a report that contains all the entries within the selected year?
Yes, that could be done. you could create a dataset based on a SQL query, then filter the dataset by year when the button is pressed. This dataset would form the basis for a report. I'll look into doing a video on that.
@@BusinessProgrammer Right, conceptually this makes sense - the most problematic part is the actual code for the macro that will be invoked by the button press (how to invoke a macro by a button press you've explained in another video
Hi Sawsan, Go to the associated blog post (in the video description above), enter your email into the yellow box that's in the blog post (not the top right) and instructions will be emailed to you.
well i tried, but i need the table with the years to be on a seperate table... its just not having it. very frustrating. anybody got any ideas? also the years selection would be nicer in a dropdown box, but this isnt critical to be honest. thanks
If you want to get up and running with useful forms real quick, watch this video, I take you through how to create a sub-grid that's dependent on the main grid, If you've any questions on this post them below.
Having cut my teeth on MS Access I found it quite hard to swith to Libre Office. This tutorial is quite simply the cleares and simplest explanation of forms and sub-forms. Thank you. It has aved me hours of wading through forum posts.
Thanks for the feedback Ian, glad you found it helpful.
Exactly I have just been commissioned to build a database in libreoffice connecting to mysql and this video has done the same for me.
Wading through messy data rich forums is just too painful.
Thank you Sean
You have got another subscriver
It's great for learning, tnx for posting.
Glad you found it helpful
Thanks! I now have a better understanding of the relationship between Form/Sub Form. Long time Access/VB programmer which has been both a help and quite in hindrance in LibreOffice.
I think the LibreOffice form / sub form way of doing it is kinda cool, shame they call a "data control" a form though. :-)
Thank you Sean. Now I understand how subforms match records.
I see now that I can even nest multiple datasources and manage their relationships with their nesting structure and setting the appropriate match fields
Yes, it's fairly powerful isn't it? Right now I'm looking at creating some tutorials that combine LibreOffice with MySql, that could be interesting....
Thanks, I now have a better understanding of the form/sub form function. Long time Access/VB programmer and that has both helped me and hindered me in LibreOffice.
great, absolutely just what i needed. thx
Glad you found it useful
Great video Sean. Thank you for your time.
Glad you liked it, Ares.
Thank you Sean for your very clear explanation on how to create data selection forms! I currently have it work on my own address database with one data selector, now I'm gonna try to figure out if I can filter on multiple selectors at once, like country/city/type of company etc. I subbed to your channel and gonna browse through your videos.
Hi Bram
Glad you liked it, I've got a LibreOffice base playlist on the channel which you may find helpful.
Thanks for an informative and easy to follow video. Having just opened Base yesterday, I feel I'm gaining foot hold in the app.
I come from a programming background - but still, for my own needs (I run a my own company) I feel that rapid and prototyping tools are many times sufficient.
Glad it was helpful!
Thanks You ! You are brilliant teacher. But How to make sub-form show all records ? Is it possible in Libra Office?
A short comment on names used to link the connection between parent/child forms: for me the names used to identify those columns are the ones I use in the SQL queries - not the ones used in UI properties (labels, names).
Hi Arne
use what ever names you want, best to have some kind of naming convention and all's good.
Hi @Sean Johnson,
thanks for the series, awesome videos.
Is there any way you could expand this a bit in a way that you show how to add a button to this existing form that, when pressed, creates and shows a report that contains all the entries within the selected year?
Yes, that could be done. you could create a dataset based on a SQL query, then filter the dataset by year when the button is pressed. This dataset would form the basis for a report.
I'll look into doing a video on that.
@@BusinessProgrammer Right, conceptually this makes sense - the most problematic part is the actual code for the macro that will be invoked by the button press (how to invoke a macro by a button press you've explained in another video
Very useful tutorial. how can we get the DB used in this video?
Hi Sawsan, Go to the associated blog post (in the video description above), enter your email into the yellow box that's in the blog post (not the top right) and instructions will be emailed to you.
well i tried, but i need the table with the years to be on a seperate table... its just not having it. very frustrating. anybody got any ideas? also the years selection would be nicer in a dropdown box, but this isnt critical to be honest. thanks