Create a form and collect data... Your suggestions for a quick and painless solution

[James E Middleton]

Somehow I have been elected to do this because I'm the most
knowledgeable.... HA!

My school want to make an application for open class day.

Basically, it looks like a survey, about ten multiple choice questions, a
few form fields, and a place for name, address, and an e-mail address.

After completing the form, we'd like the user to get a confirmation e-mail.

And, we need the results to be saved in a database.

NOTE: My ISP offers this service for free, and I have a professional survey
application BUT this has to be done in Japanese, and neither support Asian
characters.

There are a few on-line services that can handle this for a fee, but I'd
prefer not to have to go that route.

Adobe forms looked promising, but they do not supply a form handler for the
version I have. (Version 6)

Are there any fairly simple, or inexpensive solutions, or can I do it using
only FP 2003?

How would you do this, or tell someone how to do this if they had
intermediate experience and a short time to complete the task?

Thanks!

 

[Stefan B Rusynko]

To save to a DB (and send an email) you need server side scripting (ASP or PHP) and a host that supports a DB (Access or MySQl)
- the method depends on what the host supports

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Somehow I have been elected to do this because I'm the most
| knowledgeable.... HA!
|
| My school want to make an application for open class day.
|
| Basically, it looks like a survey, about ten multiple choice questions, a
| few form fields, and a place for name, address, and an e-mail address.
|
| After completing the form, we'd like the user to get a confirmation e-mail.
|
| And, we need the results to be saved in a database.
|
| NOTE: My ISP offers this service for free, and I have a professional survey
| application BUT this has to be done in Japanese, and neither support Asian
| characters.
|
| There are a few on-line services that can handle this for a fee, but I'd
| prefer not to have to go that route.
|
| Adobe forms looked promising, but they do not supply a form handler for the
| version I have. (Version 6)
|
| Are there any fairly simple, or inexpensive solutions, or can I do it using
| only FP 2003?
|
| How would you do this, or tell someone how to do this if they had
| intermediate experience and a short time to complete the task?
|
| Thanks!
|
|

 

[James E Middleton]

My host supports FP extentions, however, the option to 'send to database' is
grayed out in the form properties dialog box.

Any suggestions?

Snipped from FP 2003 Help:

a.. Prior to performing these procedures, contact your server
administrator to determine which database file types are supported, and to
ensure that the server hosting your Web site has Microsoft FrontPage Server
Extensions or SharePoint Team Services from Microsoft installed.
b.. Windows SharePoint Services 2.0 does not support Access .mdb files
because Windows SharePoint Services stores files in a Microsoft SQL
database.

1.. In Page view, right-click the form, and then click Form Properties.
2.. Click Send to database, and then click Options.
3.. On the Database Results tab, click Create Database.
After FrontPage creates a Microsoft Office Access 2003 database, a
confirmation message displays the name of the database and its location in
your Web site. For example, /fpdb/Form.mdb indicates that the database is
named Form, and is located in the /fpdb folder created by FrontPage in the
current Web site.

4.. Click OK.
FrontPage automatically selects the new database as the database
connection to use and selects the table to store the form results in.

5.. Click OK, and then click OK again.
Note If the extension of the current page is .htm, FrontPage prompts you to
rename the file with the .asp extension so that the file will work
correctly.

To save to a DB (and send an email) you need server side scripting (ASP or
PHP) and a host that supports a DB (Access or MySQl)
- the method depends on what the host supports

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Somehow I have been elected to do this because I'm the most
| knowledgeable.... HA!
|
| My school want to make an application for open class day.
|
| Basically, it looks like a survey, about ten multiple choice questions,
a
| few form fields, and a place for name, address, and an e-mail address.
|
| After completing the form, we'd like the user to get a confirmation
e-mail.
|
| And, we need the results to be saved in a database.
|
| NOTE: My ISP offers this service for free, and I have a professional
survey
| application BUT this has to be done in Japanese, and neither support
Asian
| characters.
|
| There are a few on-line services that can handle this for a fee, but I'd
| prefer not to have to go that route.
|
| Adobe forms looked promising, but they do not supply a form handler for
the
| version I have. (Version 6)
|
| Are there any fairly simple, or inexpensive solutions, or can I do it
using
| only FP 2003?
|
| How would you do this, or tell someone how to do this if they had
| intermediate experience and a short time to complete the task?
|
| Thanks!
|
|

 

[Stefan B Rusynko]

Did you do step a)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| My host supports FP extentions, however, the option to 'send to database' is
| grayed out in the form properties dialog box.
|
| Any suggestions?
|
| Snipped from FP 2003 Help:
|
| a.. Prior to performing these procedures, contact your server
| administrator to determine which database file types are supported, and to
| ensure that the server hosting your Web site has Microsoft FrontPage Server
| Extensions or SharePoint Team Services from Microsoft installed.
| b.. Windows SharePoint Services 2.0 does not support Access .mdb files
| because Windows SharePoint Services stores files in a Microsoft SQL
| database.
|
| 1.. In Page view, right-click the form, and then click Form Properties.
| 2.. Click Send to database, and then click Options.
| 3.. On the Database Results tab, click Create Database.
| After FrontPage creates a Microsoft Office Access 2003 database, a
| confirmation message displays the name of the database and its location in
| your Web site. For example, /fpdb/Form.mdb indicates that the database is
| named Form, and is located in the /fpdb folder created by FrontPage in the
| current Web site.
|
| 4.. Click OK.
| FrontPage automatically selects the new database as the database
| connection to use and selects the table to store the form results in.
|
| 5.. Click OK, and then click OK again.
| Note If the extension of the current page is .htm, FrontPage prompts you to
| rename the file with the .asp extension so that the file will work
| correctly.
|
|
|
|
|
| | > To save to a DB (and send an email) you need server side scripting (ASP or
| > PHP) and a host that supports a DB (Access or MySQl)
| > - the method depends on what the host supports
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | > | Somehow I have been elected to do this because I'm the most
| > | knowledgeable.... HA!
| > |
| > | My school want to make an application for open class day.
| > |
| > | Basically, it looks like a survey, about ten multiple choice questions,
| > a
| > | few form fields, and a place for name, address, and an e-mail address.
| > |
| > | After completing the form, we'd like the user to get a confirmation
| > e-mail.
| > |
| > | And, we need the results to be saved in a database.
| > |
| > | NOTE: My ISP offers this service for free, and I have a professional
| > survey
| > | application BUT this has to be done in Japanese, and neither support
| > Asian
| > | characters.
| > |
| > | There are a few on-line services that can handle this for a fee, but I'd
| > | prefer not to have to go that route.
| > |
| > | Adobe forms looked promising, but they do not supply a form handler for
| > the
| > | version I have. (Version 6)
| > |
| > | Are there any fairly simple, or inexpensive solutions, or can I do it
| > using
| > | only FP 2003?
| > |
| > | How would you do this, or tell someone how to do this if they had
| > | intermediate experience and a short time to complete the task?
| > |
| > | Thanks!
| > |
| > |
| >
| >
|
|