How to sum fields on a Frontpage 2003 form

We have a rally registration form where people sign up, pay an entrance fee, order t-shirts, order dinners, etc.  The form is in sections, e.g. registration, t-shirts, raffles, etc.  Each section has multiple fields all of which have to be summed for each section.  Then all the sections have to be summed for a "Grand Total".  I need a way to do all the math instead of relying on the entrants adding correctly.  The form in question is at:

http://www.gwrra-ca1r.org/rallyvalley/registration_prereg.htm
pdfentonAsked:
Who is Participating?
 
James MurrellConnect With a Mentor Product SpecialistCommented:
as both experts have said is the case, I would go with the database if you can....

also you could use a bit of JavaScript : check out http://javascript.internet.com/forms/auto-sum-form-boxes.html
0
 
coreybryantConnect With a Mentor Commented:
Frontpage forms are not that great unfortunately at doing something like this.  Your better bet is to consider using a server side language (like PHP, .NET, ASP) to help you accomplish this.

There are some categories on this board with great experts to help you accomplish this.  You just need to find out what language is supported - usually PHP on UNIX/Linux and ASP/.NET on Windows.  Contact your hosting company to see what is supported.
0
 
joeypoliceConnect With a Mentor Commented:
Another way to get FrontPage to show this is to create the sum in an access database, and then use the Frontpage database field components to show the sum value.  If not this way, then as stated above you will need to use some language.  
0
 
pdfentonAuthor Commented:
I'm not well versed in using a database with FP so will try it with JavaScript.  Thanks for the input.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.