Follow us on Twitter! Tips and tutorials
We'll be posting new tutorials on a weekly basis. So, you might wish to bookmark this page or subscribe to its RSS feed by clicking the icon to the right. Please also have a look on the video tutorials for more tips and guides.
| Topic | Description |
|---|---|
| Cascading dropdowns (video tutorial) | AppGini 4.80 introduced this new feature, where users can filter the contenct of a drop down by selecting a value from another one. For example, selecting "Honda" from "Car makes" would filter "Car models" list to show only Honda models. |
| 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. |
| Integrate PayPal links into your AppGini application | This tutorial will show you how to place PayPal links into a table view generated by AppGini. |
| 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. |
| Backing up and restoring your MySQL database | Here is a quick and easy way to backup and restore your MySQL database from a shell / command-line. It works with any charcater set. |
| MySQL2AppGini: Work with your existing MySQL database in AppGini | If you already have one or more existing MySQL databases, you can easily work with them in AppGini... |
| Formatting a field as a phone number | Q: I need to automatically format data in a field as a phone number like XXX-XX-XXXX. How can I do so? A: AppGini supports automatic formatting of data by using the Data Format tab. Select any field in AppGini, and go to that tab ... |
| Tweeting from your AppGini-generated web application | So, you created a cool application with AppGini. Now you want to post a new Tweet whenever you add new records to your application. Here you'll learn how to do so. |
| Creating a customized search form | This tutorial shows you how to create a customized search form that users can use to search a particular table in your AppGini-generated web application. |
| Creating a web-application from scratch | This is a video tutorial that will guide you through using AppGini to create a database web-application from scratch. In just 7 minutes, we'll create a simple contacts database, set it up and see it in action. |
| Inserting automatic values in fields | This tutorial explains how to set a field in AppGini to contain an automatic value. For example, setting a field that automatically records the creation date of a record, or the last modification date. |
| Displaying 2 tables in one page | A handy little hack for displaying two tables side-by-side in the same browser page |
| Creating image/file upload fields | This is a video tutorial that will show you how to create fields to upload images/files in your table. |
| Powerful CRUD scaffolding for MySQL | A description of CRUD scaffolding, and a comparison of AppGini vs. CRUD utilities, highlighting some of the extra features of AppGini. |
| Sending an email notification when a record is added or modified | In some scenarios, you might wish to send an email notification to one or more recipients when a user adds a new record or modifies an existing one. |
| Working with filters programatically, part 1 | In part 1 of this series about programming AppGini filters, we'll learn how filters work, what variables control them in code, and we'll see how to enforce a predefined filter on users when they view a table. |
| Linking to a specific record | Q: Sometime, I want to send someone a link to one of the records in a table. I don't want him to have to view all records first and then select one of them. I just want him to view the record in the detail view once he click the link. How do I compose such link? |
| Increasing the width of the rich (HTML) area | Q: How do I re-size the Rich(HTML)area in the detail view? It would be great if it could be large for easier editing. |
| Which data type to choose for your fields? | MySQL offers a lot of data types for fields. Choosing the right one can be tricky. This article sheds some light on how to decide. |
| Automatically calculated fields | Modifying the AppGini-generated code to automatically calculate the value of a field when adding new records and/or updating existing ones. |
