[Solved] Using sections in forms

Creating and using forms
Post Reply
Neelix
Posts: 6
Joined: Fri May 31, 2024 4:55 pm

[Solved] Using sections in forms

Post by Neelix »

Hi,

I created a form with two sections.

The first one named "Series", the second one named "Crew".

When I input the series data in the database, I enter in the "CREW" table, the members of the show's teaù (actors, directors, ...)

To access to the section "Crew", I insert a button "+ Equipe". I selected "Open Web Page" for both buttons Action property and enter "#Crew | region" in the URL box and "#Series | region" in the "Return" button's URL box.
Nothing happens when I click on the buttons.

Here's a sample database.

It were nice if someone could help, please.
Attachments
series.odb
(19.7 KiB) Downloaded 99 times
Last edited by Neelix on Tue Jul 16, 2024 11:01 pm, edited 1 time in total.
OpenOffice 4.1.15 on Xubuntu 18.04
UnklDonald418
Volunteer
Posts: 1566
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Using sections in forms

Post by UnklDonald418 »

o access to the section "Crew", I insert a button "+ Equipe". I selected "Open Web Page" for both buttons Action property and enter "#Crew | region" in the URL box and "#Series | region" in the "Return" button's URL box.
Nothing happens when I click on the buttons.
"#Crew | region" and "#Series | region" are not valid URLs
For instance, when I insert "https://en.wikipedia.org/wiki/URL" into the URL property of your button + Equipe
Then the button works as advertised

It appears you are attempting to create a multipage form. Since a Form document is a Writer page, it might be possible using text ranges but I’ve never seen that done successfully.

I usually create separate form documents and use macros to open and close them.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Neelix
Posts: 6
Joined: Fri May 31, 2024 4:55 pm

Re: Using sections in forms

Post by Neelix »

For some years ago, I created a turf database, inserting 3 sections linked exactly the same way, and it worked perfectly.

Here is that database:
Turf.odb
(52.14 KiB) Downloaded 103 times
OpenOffice 4.1.15 on Xubuntu 18.04
RPG
Volunteer
Posts: 2261
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Using sections in forms

Post by RPG »

Place your form in edit mode
Select the Button what give a problem
use the dialog in which you can edit a Hyperlink( menu --> Insert--> Hyperlink).

The result is that there are no spaces in the Hyperlink and you have spaces in the Hyperlink.

It is also possible that you can edit it by hand but If have not test that.
LibreOffice 24.8.5.2 on openSUSE Leap 15.6
Neelix
Posts: 6
Joined: Fri May 31, 2024 4:55 pm

Re: Using sections in forms

Post by Neelix »

You're right RPG, removing the spaces, my buttons work very well.

But how could it be ? In my turf database joined to the post, the buttons work with spaces :crazy:
OpenOffice 4.1.15 on Xubuntu 18.04
RPG
Volunteer
Posts: 2261
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Using sections in forms

Post by RPG »

I have no answer on your question in the last post. But I have the idea that there are also no spaces.
LibreOffice 24.8.5.2 on openSUSE Leap 15.6
RPG
Volunteer
Posts: 2261
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: [Solved] Using sections in forms

Post by RPG »

I agree with UnklDonald418 that separate forms work better. I did use frames in forms in the same way as Neelix use sections but I stopped with the frames and make simple forms.
LibreOffice 24.8.5.2 on openSUSE Leap 15.6
Post Reply