Quote:
|
I'm trying to eliminate the hand-work, as we expect the volume of forms processed to increase greatly.
|
That is the exact reason to automate the process. If you have the webform e-mail you every time the form is filled out and you have a lot of these forms getting filled out your day is going to end up being fill with just inserting these into the spreedsheet.
You could design the form to write the results to a text file on the server and then go in say once a day or once a week or something and download the text file and bulk process them that way.
I was imitated with php and mysql before I learned myself. One day I decided I needed to code a custom script so I got myself a few mysql books and a few php books and taught myself.
You said your entering it into a spreadsheet so the data is lingering on in some manor. Is there a reason your putting it into excel? Are you taking the info and making charts out of it or doing calculations based upon teh info? Or is excel just a storage medium?