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.
|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.|