Resolved · Low Priority · Version Standard
Victoria has attended:
Dreamweaver Introduction (2 days) course
Please can you help. I want to create a form in dreamweaver in order to gather data, which can then be fed into Excel to create a database.
As far as I can make out the information from a form is sent to me in .ATT format. Can I change this? Can it be email as an excel format or any other format?
Also my form just consists of people ticking boxes. If they were to accidently leave out a question, how would i know which question they left out. How is it possible to attach what is ticked to the relevant question,once the email is sent back to me.
Thanks for your help.
For upcoming training course dates see: Pricing & availability
Normally you would use a server side scripting (ASP, PHP, .NET, CGI) language and put the data straight into a database on your web server (MySQL, MSSQL, Access).
I would skip the Excel part out all together, unless you mean a CSV (comma separated value) file, which Excel can interpret and put into columns.
Currently, the .ATT file contains the results from your web form. This will be an ASCII text file with a bunch of strange characters betwee the data fields. You should be able to use the Import Wizard in Excel to bring the data fields into an Excel worksheet. The format is similar to a .CSV file so try renaming the .ATT file to .CSV file and open the file in Excel to see what you get.
If you haven't got time to learn a server side scripting language, there are free services out there that can do this for you, like Bravenet: http://www.bravenet.com/webtools/emailfwd/
Using server side scripting programming, you will also be able to tell when a question has not been answered (eg. your tick boxes).
If you require consultancy (where our trainers come in and do a lot of the work for you) please contact the enquiries team for more information.
I hope this helps, Victoria. If you have any follow up questions I'd be happy to help.
Kind regards, Rich