Skip to main content
G
geojf3
Participant
September 12, 2012
Question

Data Entry Forms

  • September 12, 2012
  • 2 replies
  • 1023 views

Hi all,

Although I am submitting this question in the Dreamweaver forum - please excuse me if this belongs somewhere else.

We have a form that our employees fill out and submit on a daily/weekly/monthly basis.  We get hundreds of these forms weekly.  I am trying to come up with a way to have the data filled out on-line from our website.

We host our own web site and email, so if any added software is needed it would not be a problem.  Our web site is running on a Dell server running  MS Windows 2003 R2 using IIS.  I currently have a few Active Server Pages written in vbscript running for other purposes and I only mention that to indicate that I have some experience with HTML, ASP and SQL and I can pass data from the web to our others servers.

I would like to be able to duplicate the existing paper form as closely as possible for the users to fill out.  The form is two sided and on the front it contains a section of 10 line items - but the actual number of line items that can be sent is unlimited.

We have, currently, the full Adobe suite including Dreamweaver, Photoshop, Acrobat, etc.

Any help in the creating of this would greatly be appreciated.


Thank you.

This topic has been closed for replies.

2 replies

David_Powers
David_Powers
Inspiring
September 12, 2012

I've moved this to the Dreamweaver forum that deals with developing server-side applications.

You don't say whether you want the forms to be printed out or whether the information is to be stored in a database.

For print-outs, you could replicate the forms in Acrobat and get them sent by email. To submit the data to a database, you can use Dreamweaver to create an HTML form. Dreamweaver also has some rather crude server behaviors that would automate the insertion of the data into a database. However, the server behaviors haven't been updated for many years, and they're not capable of validating the input before inserting it into the database. You would be better advised to create your own processing scripts.

Unfortunately, not many people here use ASP. Microsoft stopped development of classic ASP more than a decade ago, and most people have switched to PHP or ASP.NET.

G
geojf3Author
Participant
September 12, 2012

David, 

I just replied to Jon about the end result needing to be going to a database.

The area I need help is not moving the data to the database, but creating/copying the form and gathering the data.

Thank you.

Jon Fritz
Community Expert
Jon FritzCommunity Expert
Community Expert
September 12, 2012

I use this PHP form processing script on a few sites:

http://www.tectite.com/formmailpage.php

It works pretty slick. They also give you a basic form to start with, you can add form elements and other info using DW pretty easily. Getting it to look exactly like a printed form is a bit trickier and would require a knowledge of CSS.

Jon Fritz
Community Expert
Jon FritzCommunity Expert
Community Expert
September 12, 2012

Are you looking to have the information sent directly into a database, or just to an email address?

G
geojf3Author
Participant
September 12, 2012

Jon,

It will eventually go to a database.  But I have the vbscript code to connect to the database and update the data using a dummy form I created to test the connections..  It can even be sent to a text file at this point.  My main problem is duplicating the actual form that is needed.

Thank you.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices