Video tutorials

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

This is an 8-minutes video tutorial that will show you how to create cascading drop downs. This feature (added in AppGini 4.80) allows your application users to select a value from a drop down list to have the values in another drop down filtered accordingly.

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 101

Lookup fields (also called foreign keys) allow you to include data from a field in another field. For example, if you have a table listing your products, and another table listing your product categories, you can create a lookup field in the products table that lists the categories stored in the categories table. Lookups are a very powerful tool for data integrity. Learn how you can create lookup fields in no time with AppGini.

Video tour: Downloading table data as a CSV file

This is a video tour that will show you how to save the data for any table in the AppGini web application in a CSV file; that can be opened by Microsoft Excel or any other editor.

Video tour: Using filters

This is a video tour that will show you how to use the filters feature available in the created AppGini web application to filter the table data.

Video tour: Auto-fill fields

Learn how to set up a lookup field in AppGini that is automatically populated when you change the contents of a related lookup field.

Video tour: Creating image/file upload fields

This is a video tour that will show you how to create fields to upload Images/Files in your table.

Video tour: Creating a web-application from scratch

This is a video tour that will guide you through using AppGini to create a database web-application from scratch. In a few minutes, we'll create a simple contacts database, set it up and see it in action.

Syndicate content