Forms Help, please
Hi there. I have created my first form on an internet site for a buddy and the submit button does what it is told and sends a copy of the completed form to him.
BUT the file comes through as an .ATT attachment on email which he is unable to open. Besides, he wants to collate the information received in some kind of database.
Does anyone know how I go about getting the form to post as an Excel spreadsheet?
Virtual twinkie and warm fuzzy feeling to the first one to answer )
In case it helps, the form is on the 'new customers' section at the following URL:
TIA
Byron
Byron Hunte
Sprant - Insurance and Resources for UK eCommerce Startups
http://www.sprant.com
Mark Hensler posted this at 23:51 — 7th March 2001.
He has: 4,048 posts
Joined: Aug 2000
The only way you can make an Exel file and attach it is by using ASP and using some really dificult objects. It's not worth it.
Is his database on the server? If it's somewhere we can connect to from his web site, we can take the form info, connect to the DB, insert the data, then send him an email saying "New data entered into your database..."
PS - link didn't work for me
Mark Hensler
If there is no answer on Google, then there is no question.
sprant posted this at 09:10 — 8th March 2001.
They have: 7 posts
Joined: Aug 2000
Thanks Mark, useful info.
Byron
Christian_SEO posted this at 18:30 — 12th March 2001.
They have: 470 posts
Joined: Mar 2001
I was unable to connect to the site and see what you're using for form processing, but it doesn't matter...
I have used this with PERL and Cold Fusion. Modify the script so that it saves the fields you need in an ASCII delimited file. When you receive enough emails and want to get the data entered in to excel or a DB, just download the file and import it.
You will have to match the field order with the database field order, but a little planning will make that easy.
This is an easy alternative to an "on-line" database, but is qeared toward those with less experience.
Thanks,
Christian
Nielsen Technical Services
SEO Consultants
Search Engine Lists
Expired Domain Names
Join SEOBy.org - It's free
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.