Web form to save to Excel Spreadsheet

[thomaswee]

Hi Everyone,

New to this forum and wish to seek some helps or advise from the expert out there.

I was been tasked to develop a web form which enable the user to do the following things:

a) Example 3 checkboxes, when the user click 1st checkbox, the form will email to abc@abc.com and cc to bcd@abc.com, ccd@abc.com, as it goes. ONLY one checkbox can be clicked.

b) In one of the section, there will be about 10 columns and each column have 10 blank text boxes, need to validate them to ensure that if the user enter only one row of data into any rows available, the forum will check the data and permit accordingly

c) A auto reference number must be generated and keep track accordingly

d) When the user click submit, it will compile the form into excel spreadsheet and email out based on the checkbox the user have click.

Sorry about it but I have ready stressed myself out as I am not a web developer and hence limited knowledge in creating this form.

Appreciate if any one can give me some advise/hints so that I can move on with it. At present total lost.

Thanx
Thomas

[DrDaMour]

a lot of this COULD be done by javascript, but it would be MUCH better to do this in a server side script like php. The e-mail script pretty much has to be server side.

The only place javascript might be more appropriate than server-side is validating the form, but even that would be better on server-side. I'd suggest picking up a learn php fast book, or something like that, as it's not that difficult to learn if you have any programming background at all.