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