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.
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:
- Create a Multi-Page Form
- Simple SQL CRUD With PloneFormGen
- Dynamically populate selection fields
- Use a Selection Field to Pick Mail Destination
I recommend reading those first and understand what is being done.

