• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 27. Building Online Forms > Using the Web Form Wizard

Using the Web Form Wizard

You'll use the same Purchase Order worksheet to create a template that can be posted on a Web site. You'll first need to unprotect the sheet, then click Tools, Wizard, Web Form. This wizard involves six steps:

  1. Step 1 tells you what the wizard does. Click Next.

  2. In step 2 (see Figure 27.22), you'll see a list of controls and cell references. Begin by deleting obvious ones that you don't need, such as the references to the check boxes.

  3. By default, the field name will be the same as the cell reference. Select a reference, and the wizard will highlight the cell. If you don't need it in the database, delete the reference. If you do, type a meaningful field name in the edit box below the list of references, then click the Change Name button. The field name next to the cell reference will now reflect your change. When everything is ready, click Next.

    Figure 27.22. In step 2 of the Web Form Wizard, you select and name the fields to be exported to the database. By default, the field name is the same as the cell reference.

  4. In step 3, the wizard asks you for the type of interface used by your Web server, either Microsoft Internet Information Server or the Common Gateway Interface. If you are not sure, ask your Webmaster or your network administrator.

  5. In step 4, you must choose between saving the result as an Excel file or adding it to your FrontPage Web. To add it to your Web, FrontPage Explorer must be running and your Web site must be open in it. For now, select the option to save the results as an Excel file. (Whatever your choice, the wizard generates the same basic files.) The default file name is MYFORM, which you will probably want to change to something such as MYPURCHASEORDER. Click Next when ready.

  6. In step 5 (see Figure 27.23), you're asked to provide the information that will appear on the confirmation page sent to the user's browser after they have submitted the form. Use the default options, which can easily be changed later on, and click Next.

    Figure 27.23. In step 5 of the Web Form Wizard, you provide the information that will appear on the confirmation page seen by the user after they submit the form to your Web site.

  7. In step 6, the wizard tells you what you must now do with the files it has created for data collection. These files will have the extensions XLS, IDC, HTX, and MBD. They must be moved to the appropriate directory on your Web server for them to work properly. That location will differ from one server to another. You will also need to configure the ODBC data source, and you might need to create a new one. Finally, you must edit the IDC file to reflect the proper name for your data source.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint