I
IdaSpode
Hello to all. I mostly lurk here, only offering my limited advice when
one of you really smart guys/gals forget what it's like to be a FP
newbie and tell someone what to do without telling them how to do it.
I'm self taught and sometimes I am able to put procedures/methods into
terms and language newbies can understand. I've been using FP for
about 10 yrs now, and this newsgroup has been a most excellent source
for information, thanks to all of you who participate. Now on to my
issue:
I created and manage a web for a local motorcycle club that puts on a
two day, off road national qualifier event (timed enduro). We have
online forms for participants to register and pay entry fees.
There are two levels of entrants: those wishing to gain national
points towards qualifying for the world event team and those
recreational riders wanting to just ride the event for fun. Think of
these levels as pro and amateur.
We have approx 250 to 300 riders per day with multiple classes for
each level of entrants. I have one form on each level for “pay now
using PayPal” and one each for “mail in my payment” for a total of
four forms.
I successfully used these forms during last year’s event. The data is
going to the Access database correctly, I have custom confirmation
pages for each level and each method of payment with either PayPal
“Add to Cart” buttons or “Print this page and mail in with your pmt”.
After this club had done all this by hand with paper applications for
many years, as you can imagine, this was a welcome change for those
handling the registrations.
My only issue with the way I’ve set it up is that people being people,
many don’t fill in their correct information before hitting the submit
button. I’d like to have an intermediate “confirmation” page display
before the data is actually sent to the database. If the info is
correct, the submit button on this page would send the data to the DB
and go to the actual confirmation page. If it is not correct, a
“return to form” button would take them back to make corrections. As
it is now, every mistake filling out the form results in a new record
being created in the DB and I have to run a “duplicate entry” query to
delete the incorrect records. I'm sorry to say, dirtbikers aren't the
brightest bulbs on the tree... <G>
I have asked this question here before, it was answered and I somewhat
understand the method but I lack the coding skills to implement it.
Of course, I’d greatly appreciate if someone could write the code for
me for free, but I’m also open to paying to have it done.
I have both FP2K and Expression Web, I'm gradually trying to migrate
my skills to EW. Here is an example of one of the forms, this one
being for the recreational/amateur riders, paying online.
http://www.boiseridgeriders.org/non_app_form_template.asp
Feel free to fill out the form with dummy info to view the
confirmation page.
David
djones <at> LSidaho [dot] com
one of you really smart guys/gals forget what it's like to be a FP
newbie and tell someone what to do without telling them how to do it.
I'm self taught and sometimes I am able to put procedures/methods into
terms and language newbies can understand. I've been using FP for
about 10 yrs now, and this newsgroup has been a most excellent source
for information, thanks to all of you who participate. Now on to my
issue:
I created and manage a web for a local motorcycle club that puts on a
two day, off road national qualifier event (timed enduro). We have
online forms for participants to register and pay entry fees.
There are two levels of entrants: those wishing to gain national
points towards qualifying for the world event team and those
recreational riders wanting to just ride the event for fun. Think of
these levels as pro and amateur.
We have approx 250 to 300 riders per day with multiple classes for
each level of entrants. I have one form on each level for “pay now
using PayPal” and one each for “mail in my payment” for a total of
four forms.
I successfully used these forms during last year’s event. The data is
going to the Access database correctly, I have custom confirmation
pages for each level and each method of payment with either PayPal
“Add to Cart” buttons or “Print this page and mail in with your pmt”.
After this club had done all this by hand with paper applications for
many years, as you can imagine, this was a welcome change for those
handling the registrations.
My only issue with the way I’ve set it up is that people being people,
many don’t fill in their correct information before hitting the submit
button. I’d like to have an intermediate “confirmation” page display
before the data is actually sent to the database. If the info is
correct, the submit button on this page would send the data to the DB
and go to the actual confirmation page. If it is not correct, a
“return to form” button would take them back to make corrections. As
it is now, every mistake filling out the form results in a new record
being created in the DB and I have to run a “duplicate entry” query to
delete the incorrect records. I'm sorry to say, dirtbikers aren't the
brightest bulbs on the tree... <G>
I have asked this question here before, it was answered and I somewhat
understand the method but I lack the coding skills to implement it.
Of course, I’d greatly appreciate if someone could write the code for
me for free, but I’m also open to paying to have it done.
I have both FP2K and Expression Web, I'm gradually trying to migrate
my skills to EW. Here is an example of one of the forms, this one
being for the recreational/amateur riders, paying online.
http://www.boiseridgeriders.org/non_app_form_template.asp
Feel free to fill out the form with dummy info to view the
confirmation page.
David
djones <at> LSidaho [dot] com