[Solved] Form Navigation ToolBar vs NavBar

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

[Solved] Form Navigation ToolBar vs NavBar

Post by gkick »

Hi,

The Form Navigation Toolbar from the View Menu contains more Icons but more importantly is dynamic and usually docks at the bottom of the screen.
the Navigation Bar by contrast is tied to a form element, main form or sub form and lacks the dynamics.
I have a form which consists of a mainform and 6 table controls. For the sake of saving and refreshing I do not want to clutter the screen with multiple NavBars, so the question is, is it at all possible to have a dynamic Navigation Bar (not toolbar) residing inside the form and comes to life the very moment a change occurs anywhere.
Or alternatively is there some command aka save all which could be part of the switch forms macro?
Thks
Last edited by gkick on Sun Sep 15, 2019 5:43 pm, edited 1 time in total.
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Form Navigation ToolBar vs NavBar

Post by Villeroy »

Attach a push button.
Action = "Save Record"
Default button = "Yes"
A form can only have one default button. The default button is triggered by the enter key unless a multi-line text box has the focus or unless you are picking an item from a listbox which takes the Enter key to confirm the item selection and the next Enter will consumed by the default button.
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 Navigation ToolBar vs NavBar

Post by gkick »

Thank you Villeroy, sure is an elegant solution.

Just one flaw however as old school PC users have a tendency to move to the next field by pressing enter, which means there is an awful lot of saving happening, but then I could make the button invisible, its all still happening with the exception of the last field which will not be saved unless the user clicks on a table control or moving to another record before moving to a different form.

One thing I noticed is that table controls seem to save themselves as the save button stays inactive and the data actually is saved.
The downside of saving every single field if enter is used instead of tab, there will be heaps of duplicates in the SYSTEM VERSIONING with no change other then the timestamp.
Would it be possible to CALL save or save all from the switch to other form sub ?
Oh by the way LO 6.3 on crash goes into recover loop and switches from English to Spanish, switching back to 6.2.5 sort of stable.
cheers
GK
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Form Navigation ToolBar vs NavBar

Post by Villeroy »

Incomplete records throw errors and users will learn to tab through form controls until the record is complete. Base does not provide the perfect tool set for fool proof user interface design. By the way, html forms do the same thing. Most of them have a default button which submits the form to the server unless you edit some multi-line control. You get all kinds of errors from JavaScript or from the html server if the submitted form record is invalid.
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
Post Reply