Tips and tutorials

Video tour: Adding a file upload field

This is a screencast that will show you how to create fields to upload documents (or other files) in your AppGini application.

Modifying the SQL query of the table view using hooks



Sometimes, you need to change the data format of one or more fields in the table view. To do so, you need to edit the SQL query used to display the table view. However, you won't find this query if you search your AppGini application code! Instead, this query is constructed from an associative array coded into the generated "tablename_view.php" file (where tablename is the name of the concerned table).

Cascading drop downs (or filtering contents of a drop down when selecting a value from another drop down)

Cascading drop-downs link two listings to each other so that selecting a value from the first list, automatically filters the data in the second one.

RUView -- Resource Utilization Viewer

Fork me on GitHub
This application is shared on

Applying a default filter on a table

In many scenarios, you may find it useful to apply an initial filter on one or more of your application tables. This is very easy to achieve using the tablename_init hook. The idea is to check whether your table has any filters applied to it, and if none is applied, apply the default filter. This way, your application users will see a pre-filtered list of records, and they can then change the filter(s) later.

Filtering a lookup menu by customizing the SQL query

In this video tutorial, we'll show you how to filter the contents of the drop down menu for a lookup field. In this example, we want to stop users from adding discontinued products in an order, so we'll write an SQL query that hides discontinued products from the product lookup field. If you know a little SQL, you'll find this tutorial easy to follow.

Auto-complete lookup fields

Does your lookup drop down look huge and take decades to load? Don't panic! When the source (parent) table of a lookup field contains thousands of records, you should use auto-complete lookups to avoid heavy pages and make it easier for users to select an item from the lookup field. Learn how through this video tutorial.

Video tour: Lookup fields and master/detail pages

Lookup fields (also called foreign keys) allow you to include data from a field in another field. For example, if you have a table that show a listing of books, and another table listing book categories, you can create a lookup field in the books table that lists the categories stored in the categories table. Lookups are a very powerful tool for data integrity and creating one-to-many relationships. Watch the video and learn how AppGini makes this very easy.

Integrate PayPal links into your AppGini application


This tutorial will show you how to place paypal links into a table view generated by AppGini. Let's say that we have a table listing items for sale, like this one below.



We'll make some simple modifications so that it becomes like this:


Customizing the data displayed in the table view


Sometimes you may need to change the way data in one of your tables is displayed to users. Imagine this scenario: You have a rating field in one of your tables that takes a value between 1 and 5. Instead of displaying the rating, you want to show stars. Here is a screen shot of the table view showing the original data:

Default formatting of the table view fields.

Syndicate content