Personal tools
You are here: Home Products PloneFormGen Documentation Tutorials Creating a registration form The purpose

The purpose

To create a form which enables users to submit information to a MySQL database - creating or updating their records each time. The information is then mailed to recipients based on input in the form.

The goal of the tutorial is to show how several of the 'How To' resources can be integrated together to create a customizable form connected to a MySQL database which will mail user input to the form owner and to others as defined in the setup.
Page 1 of 3.

Why

I needed to create a meeting registration form which would add or update records in a MySQL database and mail a confirmation of the registration back to the registrant as well as to the organizers. The default Mailer is fine for the latter, but some tricks needed to be employed to create a form that would mail the registrant.

 

How

First off, much of this information (if not all) is already available from How To's and Tutorials. In this tutorial I link the above references together in the following procedure:

  1. Create a Multi-Page Form
  2. Simple SQL CRUD With PloneFormGen
  3. Dynamically populate selection fields
  4. Use a Selection Field to Pick Mail Destination

 

I recommend reading those first and understand what is being done.