[Solved]Form Navigation ToolBar vs NavBar

Creating and using forms

[Solved]Form Navigation ToolBar vs NavBar

Postby gkick » Sat Sep 14, 2019 4:32 am

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.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 52
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Form Navigation ToolBar vs NavBar

Postby Villeroy » Sat Sep 14, 2019 2:23 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27090
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Form Navigation ToolBar vs NavBar

Postby gkick » Sun Sep 15, 2019 5:07 am

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.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 52
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Form Navigation ToolBar vs NavBar

Postby Villeroy » Sun Sep 15, 2019 11:31 am

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27090
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Forms

Who is online

Users browsing this forum: No registered users and 0 guests