Tutorial How to Make Save Button and Add New Data Button in form on Openoffice Base Using Apache OpenOffice App

in #utopian-io7 years ago (edited)

What Will I Learn?

we will learn how to add push button in form on apache open office app, with this button will simplify our work when managing a database and we can save data and add new data

  • How to set up a form
  • How to add a button in form

Requirements

  • System Requirements Program Install Support: Install and Uninstall
  • System Requirements No special requirements.
  • OS Support Windows (XP, 2003, Vista, 7, 8 and 10) GNU/Linux (x86 and x86-64, RPM and DEB -
    based Linux distributions) Mac OS X (x86-64 only)

Difficulty

  • Intermediate

Tutorial Contents

Apache open officeis the app exactly the same as microsoft office, but apache openoffice is opensource, here we can find the facilities such as, openoffice presentation, openoffice calc, openoffice base, and others. on this occasion I want to share about openoffice base equivalent to microsoft access on microsoft office, with open office base we can create a databse and set it up in such a way, create a query, create a table, create a report and create a form, on this occasion we focused on the form that is how to create a form and add a button on the form.

make sure you have create a database firs, the goal is to make data storage - data that we will input later on the form by using the button or add new data by using button add new data later, after that go to the form and click on the "use wizard to create form"
1.png

next click the aero right icon to move or for enter all data to the form
2.png

and then click on next
3.png

and now set the form as you want and enter name for the form, here I suggest to choose "columnar - labels on top" on arrange controls for simple form and easy to use.

after you set up the form design in such a way next select the button on the left toolbar, And add 2 buttons, a buttonto save, and another one to create new data, next right-click on each button and select the control to add the label and action.

5.png

image.png

image.png

next save this form, and now we're trying to operate it, to open the form that has the way is back on display the beginning of the open office base on the menu of the form double click on "Frm_student". to ensure the form works fine please input the data for the experiment according to what you want. for example, like this :

image.png

and click on save button that has been made, and make sure the data has been stored by the way check it out on the table in the database.

7.png

if the data saved then it will automatically be stored in the database, the image above shows how the function of the save button works fine, when the data in the save, next we will try with the function button next button add new data where when the button is operated in the automatic form the form will provide a new line or removes (not deletes) the data that has been entered last.

image.png

and make sure that display when you click on the add new data button will be like the picture above, if so then the 2 buttons that we have created is functioning properly, to add new data you just need to click on add new data and to store data that has been added you just need to click on the save button, in addition to making the 2 button's here. we can also make more button how to choose what functions we want in action, just the tutorial on this time, and see you.



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

Your contribution cannot be approved because it does not follow the Utopian Rules.

  • The Github repository linked to a Utopian contribution post must contain the project’s source code, a readme and a license.

  • Submissions to this category must include technical instructions that use text and graphics to clearly explain and teach significant aspects of an Open Source project.


Also, this tutorial has not handled technical elements related to the project.An open office project is not maintained in github repo(https://openoffice.apache.org/get-involved.html) and the repo you linked in the posting don't have readme, license files.

You can contact us on Discord.
[utopian-moderator]