Created attachment 116175 [details]
sample load form at strtup option
I would like to make a recommendation to automatically load any form when base is opened on start up. The check box would allow users to enable/disable the function while providing a better user iterface experience during loading on base programs.
Under options>>Libre Base>>insert startup.
Have a checkbox that says " automatically load form at startup
Underneath checkbox have a drop down box with all the forms you can choose from.
Thank you for helping us to improve LibreOffice.
I am asking for the attention of the user interface team.
(In reply to Terrence Enger from comment #1)
> Thank you for helping us to improve LibreOffice.
> I am asking for the attention of the user interface team.
Status -> NEW
We're replacing our use of the 'ux-advise' component with a keyword:
Component -> LibreOffice
Add Keyword: needsUXEval
Not sure if loading a database makes sense, or if the user rather expects a table/form etc. But having a shortcut to frequently used data makes sense.
(In reply to Heiko Tietze from comment #4)
> Not sure if loading a database makes sense, or if the user rather expects a
> table/form etc. But having a shortcut to frequently used data makes sense.
What do you mean "having a shortcut to frequently used data" ?
The initial proposal makes perfect sense for a database user that uses ODB files with embedded forms - it seems like a very good proposal to me.
Currently, the only way to have a form load on startup is via a macro, or an extension containing macros that serves as a gateway to the forms to be loaded (with event activated buttons).
The initial proposal suggests having a UI under the Base entry that would allow the user to decide whether any registered ODB datasource should be opened with a given form instead of the basic Base application window, query the list of available forms from the ODB file, and allow the user to choose which form should be loaded on opening the file.
IMO, this could probably also be implemented from the registered datasource dialog under Options > LibreOffice Base > Databases and then Edit
on one of the already registered databases. Currently, this Edit dialog only allows the user to point to an ODB file and give it a name, but it could be expanded in the way suggested to allow for selection of a form to be opened when the ODB file is loaded.
If that were implemented, one would also need to provide the same option in the ODB database UI somewhere, such as under the Tools menu, or perhaps more logically, an option in the Forms window to select a default form to be loaded on startup. In this way, one wouldn't be reliant on having to register the ODB file with the office application (however, I'm not sure that this is actually possible within the current code for non-registered database files).
It might also be worth asking Lionel (the Base code caretaker) what he thinks of such an idea...
@Lionel : anything to add ?
Can be done with a Macro right now. Yes, would be nice to have a more user-friendly way to put that in place (not all users are able to write macros).
(In reply to Alex Thurgood from comment #5)
> What do you mean "having a shortcut to frequently used data" ?
The proposal is a shortcut but there might be other solutions. The actual use case is to quickly access the last data (phrasing it as generic as possible). And an alternative solution could to have something like the 'template manager' in Impress. But I would go with the simple solution as suggested.
(In reply to Lionel Elie Mamane from comment #7)
> Can be done with a Macro right now. Yes, would be nice to have a more
> user-friendly way to put that in place (not all users are able to write
I believe one of the core issues here is a way to designate a default form, which is automatically opened when the ODB file is opened, that does not bring the security mechanism into play which is the case when a macro is required.
(In reply to Drew Jensen from comment #9)
> (In reply to Lionel Elie Mamane from comment #7)
> > Can be done with a Macro right now. Yes, would be nice to have a more
> > user-friendly way to put that in place (not all users are able to write
> > macros).
> I believe one of the core issues here is a way to designate a default form,
> which is automatically opened when the ODB file is opened, that does not
> bring the security mechanism into play which is the case when a macro is
sorry for double posting - but should add.
This default form (sans macro security setting requirements) would be nice but it is only half a solution unless there is a way to open any form (or run a report) from a setting of UI controls which which again doesn't require macro:
- standard button action to open a form that takes at design time a form name and that works with an embedded form.
- a way to place a menu item/toolbutton on a form, in the customization dialog, which opens a form or runs a report. One solution might be to create an interface similar to how you add a macro call to a toolbar or menu now, but in the available list of items have the current forms/reports embedded in the ODB.
Anyway, that is my .02 worth of thought on this ;)
Just want to support the idea
its a feature you really need
if you want to an BASE application
to a end-user