[Solved] Form design question

Creating and using forms
Post Reply
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

[Solved] Form design question

Post by gkick »

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
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
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Form design question

Post by Villeroy »

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
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
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Form design question

Post by gkick »

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 ?
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Form design question

Post by Villeroy »

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
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Form design question

Post by gkick »

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
Post Reply