Bug 91752 - Libre base recommendation to load forms at startup
Summary: Libre base recommendation to load forms at startup
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsDevEval
Depends on:
Blocks: Options-Dialog Base-UX Database-Forms
  Show dependency treegraph
 
Reported: 2015-05-30 13:51 UTC by ELSUPREMO1
Modified: 2019-05-07 15:30 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
sample load form at strtup option (91.49 KB, image/jpeg)
2015-05-30 13:51 UTC, ELSUPREMO1
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ELSUPREMO1 2015-05-30 13:51:13 UTC
Created attachment 116175 [details]
sample load form at strtup option

Hi,

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.
Comment 1 Terrence Enger 2015-05-30 15:04:30 UTC
Thank you for helping us to improve LibreOffice.

I am asking for the attention of the user interface team.

Terry.
Comment 2 Robinson Tryon (qubit) 2015-06-04 14:18:23 UTC
(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.

ux-advise:
Status -> NEW
Comment 3 Robinson Tryon (qubit) 2016-08-25 05:39:19 UTC Comment hidden (obsolete)
Comment 4 Heiko Tietze 2017-07-19 12:02:19 UTC
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.

(UnCCing ux-advice)
Comment 5 Alex Thurgood 2017-07-20 14:04:22 UTC
(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...
Comment 6 Alex Thurgood 2017-07-20 14:05:05 UTC
@Lionel : anything to add ?
Comment 7 Lionel Elie Mamane 2017-07-20 14:14:08 UTC
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).
Comment 8 Heiko Tietze 2017-07-20 14:57:28 UTC
(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.
Comment 9 Drew Jensen 2018-08-19 16:02:55 UTC
(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 required.
Comment 10 Drew Jensen 2018-08-19 16:12:02 UTC
(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
> required.

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 ;)
Comment 11 erich 2019-03-16 11:27:48 UTC
Just want to support the idea
its a feature you really need
if you want to an BASE application
to a end-user