?
Solved

How to sum fields on a Frontpage 2003 form

Posted on 2010-11-23
4
Medium Priority
?
866 Views
Last Modified: 2013-12-24
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
0
Comment
Question by:pdfenton
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 29

Assisted Solution

by:coreybryant
coreybryant earned 400 total points
ID: 34201286
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
 
LVL 6

Assisted Solution

by:joeypolice
joeypolice earned 400 total points
ID: 34204290
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
 
LVL 31

Accepted Solution

by:
James Murrell earned 1200 total points
ID: 34222816
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
 

Author Comment

by:pdfenton
ID: 34241380
I'm not well versed in using a database with FP so will try it with JavaScript.  Thanks for the input.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question