LibreOffice Base: settings additions modification in form properties

English
#1

Hello everyone,

I am new to LibreOffice Base.

I trained in the basics through tutorials on YouTube.

Regarding form properties, here is my question:

Is it possible to configure the sections “Allow additions, modifications, Add only data” by using the “Add”, “Modify”, Delete”, “Create” buttons?

My objective is that a user arrives on a form in consultation mode and can only modify, delete, add, thanks to buttons, themselves configured…

I have been looking for several days, but without success.

If not, are there any workarounds?

Thank you in advance for your answers, hoping to be one day among those who help…

#2

The allow options makes a form editable, deletable or insertable. “New record only” makes the form load to the new record skipping all the existing records. If the allow options are enabled and the form’s record set is editable and “new record only” is off, you can delete the current record and you can edit the current record and you can jump to the new record and enter the data of a new record,
Form navigation is implemented by the navigation toolbar or a navigation control attached to the form or by single buttons with action properties set to “new record”, “delete record”, “save record” or some navigation direction. A record is saved automatically when you move to another record.

#3

Thanks for your reply, but what I’m looking for is a solution where user could be allowed or not to edit, create or delete records depending on some programmable access rights.

#4

And where will be the information about the rights of the user connected to the database?
Usually rights are given in relation to specific program objects: tables, views…

#5

User priviledges are a matter of the database engine. Base is not a database. Base is a tool to work with databases. Connect a Base document to something like MySQL server with groups and users and tell Base to enforce user login.

#6

Dear all, thanks for your replies but this is NOT about user rights.
This is just about programming and depending on the way the form is open.
Thanks

#7

At the form (subform) level, you can use Form Properties... dialog, tab Data, properties Allow additions, Allow modifications, Allow deletions.
See also AllowInserts…

1 Like
#8

Thanks for the link, we are getting closer to what I’m looking for.

#9

Wich ways “the form is open” you know? I know only design mode ON (change the form, but no data) or OFF (change data, but not the form).

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.