Hi all,
Lets say we have a table with a considerable number of fields like
Id,date,a1,a2,a3,a4,b1,b2,b3,b4,c1,c2,c3,c4,c5,d1,d2,d3,d4 ........
In a table control what would be the most practical way to switch the display of field groups so that for
example the form will show
Id,date,a1,a2,a3,a4 or
Id,date,d1,d2,d3,d4 or
Id,date,b1,b2,b3,b4,c1,c2,c3,c4,c5 etc
Thanks for your thoughts
[Solved] Form design question
[Solved] Form design question
Last edited by gkick on Thu Oct 08, 2020 9:06 pm, edited 1 time in total.
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
Re: Form design question
Put a few columns into the table control and the rest into stand-alone form controls. This way the table control allows to distinguish between similar entries and the stand-alone controls show details about the currently selected items.
For instance, you may show sorted names and birth dates of persons in the grid in order to find the right person easily you get all the details in separate controls.
Ruiz | Julio | 1955-06-01
Smith | Alfredo | 1987-10-23
Smith | Bella | 1970-01-31
Snyder | James | 1999-12-01
For instance, you may show sorted names and birth dates of persons in the grid in order to find the right person easily you get all the details in separate controls.
Ruiz | Julio | 1955-06-01
Smith | Alfredo | 1987-10-23
Smith | Bella | 1970-01-31
Snyder | James | 1999-12-01
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Form design question
Hi and Thank you Villeroy,
Hmm, not really an option as all the fields have to be displayed in the same screen location and the date field always being the first field.
Is there a way to group fields of a table control and then just toggle the visibility ? and if lets say we toggle all but the b group off, would the b fields actually shift to the left ?
Hmm, not really an option as all the fields have to be displayed in the same screen location and the date field always being the first field.
Is there a way to group fields of a table control and then just toggle the visibility ? and if lets say we toggle all but the b group off, would the b fields actually shift to the left ?
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
Re: Form design question
All the properties are in the properties dialog. There are no hidden features.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Form design question
Well, figured the options are multiple table controls on top of each other toggling the table controls visible property or alternatively just one table control toggling the visible property of all the individual fields.
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend