Calculations in a form?

Hello,

Is there a best/easy way to include a form that can do calculations?

I have clients that want "Order Forms" which would inlude:

Item Name, Price, the customer enters the quantity, which multiplies by the price per unit which then would add in the Total Cell.

Should I just create it in Excel and/or an Adobe product and then have it download as an attachment that can e-mailed back, instead of trying to come up with an order form that will do calculations and then send that information via e-mail to an appropriate person.

I hope my question makes sense.

Thanks for any input and ideas anyone may have!

Take care,

Mark

I think the only way you will achieve this on one page is via javascript. Either using the OnBlur on a text field or OnClick to get the total.

If you are happy that the totals are shown on a separate page you could use PHP, post the form elements and calculate the POST values.

Cheers
Ian

Hello and thanks for your response!

I just want to create a basic order form.

I am fine with them downloading a Word Document or Excel Spreadsheet or Adobe Form and then the visitor completes the form on their computer and e-mails or submits and attaches the file.

I need a form that will do simple math.

Customer wants one chair at $5 per day for two days = $10 and then a total at the the bottom of the form.

They do not have to complete the form online.

Based on that information, do those options sound viable?

Thanks again!

Mark

this will require hand coding javascript to accomplish.

see this tutorial i found through Google:
ttp://www.javascript-coder.com/javascript-form/javascript-calculator-script.phtml