HTML Help! (Forms....)

[blues008]

Hey all,

I have a question about form submissions. By default I believe they are sent as emails...is there any simply way to have the data continually sent to an Excel spreadsheet? Or is that something that I need to hire someone for?

Thanks!
blues

 

[Descartes]

Last I checked, Excel spreadsheets weren't part of the HTML standard

So, in short, yes, you'll have to find someone to do it for you.

 

[purplehayes]

I don't mean to be rude, REALLY, but if you have to ask, you've either got a lot of studying to do or you can hire someone to do it for you.

PH

 

[Pretender]

uh form submissions aren't done by email by default...(or am I wrong?)

 

[blues008]

I thought you could with FrontPage Extensions.

Am I wrong on this?

 

[nEoTeChMaN]

One click with Dreamweaver 4 and POOF!! you'll have a form submission in no time.

 

[Warpo]

Form input is sent to a specified script which can either be local or on another server (specified by the ACTION attribute). If programmed to, the script could send the webmaster an email with the form contents, but sending directly through to email is impossible.

 

[ghostman]

form submission don't have to be handled by email...it's handled by the script that is envoked by the form. The script can then be told to send email...or possibly append to a file. Of course, Excel spreadsheets are binary files (right?) so it'll be a sucker to add on to unless there's some program that does this. Easiest would probably to append to a text tab delimited file, which Excel can import without a hitch.

No clue about front page extensions though, so you're on your own there. I'm thinking perl...

 

[ghostman]

<< but sending directly through to email is impossible. >>



actually, I think you can stick something like &quot;mailto:email&quot; in the action....something along those lines I believe. The output will come out escaped and with + for spaces and &amp; for field separators, but nothing a little javascript can't fix up. I could be totally wrong on this though, but it's lurking in the back of my mind...

 

[blues008]

I tried with Dreamweaver 4, and I can actually get a mailto Action - so information does get submitted to me via email after using a CGI script.

But I still need to figure out how to get it to submit information to either Access or Excel...

blues