Ask Your Question
0

Can I create a form in base with more than one page?

asked 2020-07-11 19:24:44 +0200

Panchopar gravatar image

I want to create a 2 page form for libreoffice base. Is that possible and how

edit retag flag offensive close merge delete

Comments

Hello,

Forms do not have a fixed size and therefore cannot be compared to a page. Please explain what your intention is. Have seen this mean many things to may posters including the continuation of entry started on one form and finished on another.

Although probably not relevant, it is always best to include your OS, the specific LO version used and for Base the database used (and connector when applicable).

Please use add a comment or Edit question to respond and not an Answer as this is to actually answer the question.

Ratslinger gravatar imageRatslinger ( 2020-07-11 20:17:06 +0200 )edit

I am using Mysql on a Ubuntu server. Using windows 10 with libreoffice 6.3 base connecting direct to the server on same lan. I want my form to have 2 pages for data entry but only one to print page one for customer. Page 2 will have info that only our store needs to see. Thanks for all your help.

Panchopar gravatar imagePanchopar ( 2020-07-11 21:13:33 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2020-07-11 22:02:21 +0200

Ratslinger gravatar image

Hello,

Based on your information, there will be much to adjust to. It may even be an incorrect design. Splitting data onto two forms requires the second form to contain non-required information. That is because once you leave the first form, that record is written to the table. Also in dealing with this you will need to write macros to open the second form at the same place as the first form left off. Here are some links for this:

https://ask.libreoffice.org/en/questi...

https://ask.libreoffice.org/en/questi...

https://ask.libreoffice.org/en/questi...

Now to eliminate all this hassle, it is better to enter all information on one form. Then call up a second form (read only) and use that to print. Or, use Report Builder to create a report specifically for this.

Now if you are actually wanting a customer to enter data on the second form, well that is a whole bunch of more problems I would completely avoid.

edit flag offensive delete link more

Comments

As with all questions, if this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

Ratslinger gravatar imageRatslinger ( 2020-07-11 22:07:41 +0200 )edit

I don't want to use 2 Forms just a second page on the one and only form. Can I format the form page to use more space . and when printing have it not print the second page(space)?

Panchopar gravatar imagePanchopar ( 2020-07-11 22:32:38 +0200 )edit

@Panchopar,

The easiest way to get more space, in editing form, use the zoom slider in lower right on status bar and lower the zoom level. Add a control in the lower right (any control - even a label). Now place the zoom level back at 100%. Area is larger. There is a open bug report dealing with tabbing to controls which are not initially visible. See tdf#93287

As for printing, when printing a form there is no selection. Same response as in answer -

Then call up a second form (read only) and use that to print. Or, use Report Builder to create a report specifically for this.

Ratslinger gravatar imageRatslinger ( 2020-07-11 23:24:59 +0200 )edit

Another method, if just height is needed, select the form background. Then press Enter until the desired height is reached.

Ratslinger gravatar imageRatslinger ( 2020-07-12 03:43:04 +0200 )edit

thanks I changed the page format to 8.5 by 14 and all seems to work as I wanted it to. Thank to all.

Panchopar gravatar imagePanchopar ( 2020-07-12 20:42:05 +0200 )edit

Glad you have something which works. Avoided that solution as it does not work under Ubuntu 20.04 with LO v6.4.5.2

Ratslinger gravatar imageRatslinger ( 2020-07-12 21:34:56 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-07-11 19:24:44 +0200

Seen: 51 times

Last updated: Jul 11