FORMfields, the premiere web framework
Login
Support Home | Knowledge Base | Documentation | Forums | Contact Us
Info
FORMfields & FORMgen :: Getting Started

Getting Started with FORMgen Lite

(3869 views. Last Updated: 2007-09-21 3:52 PM)

If you have downloaded and installed FORMgen on your own website, please read http://www.formfields.com/support/viewPosting.php?pi=9 instead of this posting.

This tutorial assumes that you already have a web hosting account with PHP and that you have completed the setup instructions at http://www.formfields.com/FORMfieldsArea/FORMfields3/tutorials/FORMfieldsInstallation.php

In this tutorial we will create a series of simple forms that will collect a Name and Email address from a new contact, store this information in your database and also send this information to you in an email. For this example, we will assume that your website domain name is www.mysite.com and that your email address is info@mysite.com.

--------------

CREATING THE FORMS AND DATABASE TABLE:

- Go to http://www.formfields.com/FORMgenArea
- Click Next.
- Step 1: click Next.
- Step 2: Enter New Contact, press tab and then click Next.
- Step 3: click Add Field.
- Select Field Type: PersonNameField, Name: name, Label: Person's Name, Required: Required, Field Help: Please enter your complete name. Then click Save.
- Click Add Field.
- Select Field Type: EmailAddrField, Name: email, Label: Email Address, Required: Required. Then click Save.
- Click Next.
- Step 4: click Next.
- Step 5: check On Submit Insert Form Data Into Database. Under the Form Email 1 section, enter Email To: info@mysite.com and enter On Email From: info@mysite.com. Optional: check On Submit Display Confirmation Screen. Click Next.
- Step 6: Click to download new_contact.php, new_contact_table.sql, create_new_contact_table.php, and cp_new_contact.php to your local hard drive.
- Use an FTP client to upload new_contact.php, new_contact_table.sql, create_new_contact_table.php, and cp_new_contact.php to www.mysite.com in the directory /FORMfields/forms/. (Please see http://ftphelp.secureserver.net/index.html for tutorials on how to use FTP clients. You can download most of these FTP clients for free by doing a google search for each FTP client).
- Visit http://www.mysite.com/FORMfields/forms/create_new_contact_table.php
- Now you can put a link on your website to the form at http://www.mysite.com/FORMfields/forms/new_contact.php. Also, you, the administrator, can use http://www.mysite.com/FORMfields/forms/cp_new_contact.php to administer your database data for this form.

--------------

EXPORTING DATA:

Adding Test Data:
- You can use the form at http://www.mysite.com/FORMfields/forms/new_contact.php to submit data just like a regular user would. Or, you can go to http://www.mysite.com/FORMfields/forms/cp_new_contact.php and click on New Record to insert data as an administrator.

Exporting The Data:
- Go to http://www.mysite.com/FORMfields/forms/new_contact.php and click on Download new_contact.csv. Then save this file to your local hard drive.
- Open MS Excel and select File->Open and open new_contact.csv.
- Some values may show up as "#####" or may appear to be incorrectly formatted. To fix this, just increase the width of the column accordingly.

--------------

IMPORTING DATA:

- Go to http://www.mysite.com/FORMfields/forms/new_contact.php and click on Download new_contact.csv. Then save this file to your local hard drive.
- Open MS Excel and select File->Open and open new_contact.csv.
- Some values may show up as "#####" or may appear to be incorrectly formatted. To fix this, just increase the width of the column accordingly.
- Edit your file and then click File->Save and then Yes.
- Go to http://www.mysite.com/FORMfields/forms/new_contact.php and browse for newcontact.csv in the Upload File box. Then click Upload Now.
Info
Support | Earn Money
Copyright © 2005-2019 Brain Book Software LLC.
Built with FORMfields, the premiere web framework.