Creating a web database application in 5 minutes using AppGini

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
If you are looking for a way to make a user-friendly, fast and feature-rich web application in a very short time, that's when AppGini comes handy. First we'll start a new project. Let's give it a name: in our example we'll name it "product catalog". Then we'll add two tables one for "categories" and another one for "items". You can assign an icon for each table by clicking on the box at the left of the table name. Next, we'll add fields to each table. Each table MUST contain a primary key field. If you name a field "ID", it will automatically become a primary key. You can add as many fields and tables as you need. Now, let us try out some of AppGini's features. If we set a field as a look-up, it would be displayed to users as a drop-down, listing data from another table. This makes your web application more organized. We'll set the "category" field as a look-up field simply by clicking on the "look-up field" tab, selecting "category" as the "parent table" then "category name" as the "parent caption field". In addition, if you want to list items under each category, , you'll need to configure the "categories" table by opening the "parent/children settings", select the "items" table, check "enabled", "show icon" and optionally rename the "tab title" to a more descriptive one. All you need to do now is to generate your web application by clicking the magic stick icon. Choose your application path and AppGini will do the job for you. These are the files generated by AppGini. Let us visit our web application and see this in action. This is the setup data page. Once we are done filling it, we start using our application. As you can see, both tables appear on the first page. Let's go to the "Categories" table and enter some data. Here you can see the table fields. To start adding a new record simply click "Add new". You will automatically be directed to the Data entry page, also known as Detail view form. We'll enter Dresses and T-shirts as an example. Simply press "back" to see how the table looks like. Once we're done, we jump to "items" table and start adding our data for this table as well. Do you see how the "category" field is displayed? It's a drop down menu, because we set it up as a look-up field in AppGini. The drop down lists the categories that we entered a moment ago in the "categories" table. AppGini offers special features for fields with immutable data like "size" and "target groups". This is how the "items" table looks after adding our data. Now let us go back to AppGini to see how to make use of its features. To create a drop-down list, click on the field name, then on "options list", and type all values you need, separating options with double semicolon. You can choose among three options for how to display your options list. In our case we will choose the "drop-down list". We'll perform the same steps for the "target group" field, but this time we'll choose "radio buttons" instead of "drop-down list". Once we generate, we get back to our web application, refresh the page and start adding a new record. So this way our "size" field became a drop-down field and our "target group" field became a radio buttons field. Finally, this is how our table looks like. To get to know more about AppGini, please visit our homepage for more video tours.
Info
Channel: AppGini -- Web applications in minutes!
Views: 467,028
Rating: 4.7829037 out of 5
Keywords: AppGini, database, lookup, master-detail views, web application
Id: 9dtXEt2wBIg
Channel Id: undefined
Length: 5min 26sec (326 seconds)
Published: Mon Jan 19 2015
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.