Forms, Results & Confirmation Page

[sforeman]

I am creating a registration form in FP2003 for a conference and am stuck in
a few places.

I have limited number of seats for different classes and I could use
suggestions on how to set an overall limit. Obviously, the field validation
isn’t sufficient.

Is there a way for me to do calculations in form fields? Ex., # attending *
fee

The data result fields on my confirmation page does not show. Only the
field names (web components).

Once you click submit form, I get a default confirmation page instead of my
page. You have to click back to form to see the confirmation page.

Can I format the htm results file that is emailed to not just list data
spanning across page?

I need results sent via email and would like the file to be an Access file
so that they can just update their database-is this possible. What are your
suggestions of sending them the results since they won’t have access to the
database saved on the server.

Thanks for your assistance.

 

[Stefan B Rusynko]

You can't do class size limits client side
You must do it server side by saving a variable ( to your Access DB) w/ the last class count (starting w/ the limit as a value) and
then decrement that count in the DB w/ each new registration
- also use your DB to store and display the registration form results

For in page math use JavaScript
- see http://irt.org/script/form.htm

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I am creating a registration form in FP2003 for a conference and am stuck in
| a few places.
|
| I have limited number of seats for different classes and I could use
| suggestions on how to set an overall limit. Obviously, the field validation
| isn’t sufficient.
|
| Is there a way for me to do calculations in form fields? Ex., # attending *
| fee
|
| The data result fields on my confirmation page does not show. Only the
| field names (web components).
|
| Once you click submit form, I get a default confirmation page instead of my
| page. You have to click back to form to see the confirmation page.
|
| Can I format the htm results file that is emailed to not just list data
| spanning across page?
|
| I need results sent via email and would like the file to be an Access file
| so that they can just update their database-is this possible. What are your
| suggestions of sending them the results since they won’t have access to the
| database saved on the server.
|
| Thanks for your assistance.