Adding fields in a FP Form

[Graham Skaines]

I have created a form named 'FrontPage_Form1' I have three fields called
'Amount1' , 'Amount2' and 'Amount3'. What I want to do is have a field that
adds the three amounts as they are entered and show the value in a field
called 'Total'. This form saves to an Access database.

Is there a simple script that I can add to the page to do this and where
abouts do I add it in the html code.

Thanks
Graham

 

[Tom Gahagan]

Hi Graham.......

Of course, "simple" is a relative term!

Your form submit can call a simple asp (or php if you are on a unix host)
page that can do all the database work.... add the three fields...puts the
sum in a field that holds the total.... then returns to show the completed
work. Not all that complicated... if you've done a little asp or php
work and even if you've not.. I bet you can pick it up pretty quick.

If you have not.... a good place (or two) to find tons of example code to
get you started and for asp help would be...

www.planet-source-code.com
www.4guysfromrolla.com

for php stuff check out... www.hotscripts.com (they have lots of other
stuff their too besides php scripts.

So I guess the answer is yes... it can be done. Don't be afraid of the asp
or php stuff it really is not all that hard and you put the code right in
the same file as your html.

Hope this is a help.
Tom Gahagan
eThomaston.com