Building Database Application - Basic
MyEzApp.com allows you to build online database application easily and use it for free. No coding is required if you like the generated application. If you want to enhance the application, the complete source code is available. You can customize it as you wish.
This tutorial will walk you through building a basic database application with a single table. The Advanced Tutorial will show you how to build database application with multiple tables and how to link them together.
The steps of this tutorial is recorded in a 2 minutes screencast.
To start building database application, you need to use the application builder. You can find the application builder on your user's homepage once you login into the myezapp.com. Click on the 'Build Apps' icon will launch the application builder.
Below is the screenshot of the application builder:
You can build several types of applications using the application builder. For this tutorial, we will build a database appliciation. Please click the 'Create' button inside the 'Database Application' section. It will start the database application wizard.
The first step in building your own database application is to sign in to your myezapp account. If you have already signed in, the database application builder will go straight to step 2.
On step 2, you will need to specify some basic information for the application, such as the 'Application Name'. Default values will be automatically populated in the required field. You can modify them to suit your need, or simply take the default.
In this tutorial, assuming that we will be building a database application that manages a list of student. Let's change the application name to 'Student List', then click 'Continue'.
Step 3 is the most important step for building database application. In this step, you will define tables for the application.
The database application builder will generate application that stores data in a table format. For example, if you are a teacher and you want to keep track of all your students. Each student would have a first name, last name, etc. Accordingly, you can define a table with a first name column, a last name column. In turn, the database application builder will generate a custom application based on this structure.
You can also associate a type with each column of a table, such as 'Text' or 'Number'. Based on the type, the database application builder will generate appropriate behavior.
Now, let me show you how to define the student table. On the define tables page, please click the 'Add Table' button.
Once you clicked the 'Add Table' button, you will open up the 'Add Table' page.
The add table page allows you to specify the name of the table, how you want the table to be displayed, and the list of columns that the table has.
In our example, let's define the table name to be 'Student'.
Next, you need to add columns to the student table. Let's add the column 'First Name' to the student table. Similarly, let's add the column 'Last Name'.
Next column is 'gender'. It would be nice if we can select gender from a drop down list as oppose to enter it as text. To do this, let's choose the 'lookup' type for the 'gender' field. The format of a lookup is the list of values separated by a whitespace. In case of the 'gender' lookup, let's enter 'Male Female'
Next field is date-of-birth. It has the type 'Date/Time'. The default format of the 'Date/Time' type includes both the 'date' and 'time' information. For date-of-birth, we only need the 'date' information and we don't care the exact time. Therefore, let's select the 'Date Only' for the format.
Next, let's add the field 'parent_name'. It has the type 'Text'.
Next, let's add the 'phone' field. There is a specific field type called 'Phone'. Let's select it.
Next, let's add the 'email' field. There is a specific field type called 'Email'. Let's pick it.
Next, let's add the 'address' field. There is a field type called 'Location'. Let's choose that.
Next, let's add a notes field. In case you want to capture some extra information about the student. Let's use the type 'Rich Text'. The difference between 'Text' and 'Rich Text' is that: 'Text' will be displayed as a simple input box; while 'Rich Text' will be displayed in a text editor component.
Before we complete the student table, let's specify its object label The object label is a short label for a student object. It is used when other tables are referring a student object. Let's set its format to 'Last Name,First Name'.
Below is the screenshot after you specified the student table
Now, we have defined all the information for the 'student' table. Let's click the 'Save' button. This will bring you back to the define tables page. On the define tables page, you should be able to find the 'student' table. There are links for you to modify, or delete the 'student' table.
Once you defined the student table, you can generate the application. Please click the 'Generate Application' button.
Once you clicked the 'Generate Application' button, you will be redirected to the next step 'Complete'
The 'Complete' step is informational. No additional input is needed at this step.
To use the 'Student List' application, you simply click the 'Student List' icon on your user's homepage.
When you click the 'Student List' icon, you will open up the 'Student List' application dashboard.
The dashboard contains 4 sections - Data Entry, Setup, Browse and Report
Now you can start adding student. Below is an example of the 'Add Students' page. As you can see from the screenshot, Gender is displayed as a drop down while date-of-birth is display using a date picker.
After adding student information, you can go back to the dashboard and see the list of student you just added.
As you can see from the screenshot, there are several links generated per student. The 'id' link will drill down to the student details page. The email link will trigger the email client on your desktop and pre-populate the 'To' field with that email address. The address link will open up google map for that address. There are also links under the actions column that allows you to modify or delete the student record.
On the top right corner of the table, there are buttons for you to export the data into various formats, such as CSV, Excel, PDF, etc.
This tutorial shows you how to use the database application builder to build a basic database application with a single table. You can also build more advanced application with multiple tables and link them all together. The Advanced Tutorial will show you how to do that.
Try it out and have fun!