Hi,
Is there a way to limit the number of form submissions?? I have a summer camp that is limited to 150 kids. Is there a way to have the form stop at 150? It would be even nicer if it came up with a message that said...sorry but the camp is full.

Thanks much,
M

Not within the app itself. It will take some custom coding with php and MySql to get that sort of thing done.

I have a enough experience to be dangerous with sql and php but would hate to totally screw up my form lol.

Thank you for the reply.
M

An easier way (manual of course not automatic) would be to create another web page that you can alternate with, or just alter the code and add a Paragraph that tells people, sorry the event is full. Then comment that out and let the form go until it's full. When the event is full, edit the page so that you comment out the form code, and uncomment the paragraph, and alternate as necessary.

Not a perfect way, definitely not automatic, but it would work

JoAnns approach is a good fast and easy. Your going to be monitoring the results closely anyways making sure you get enough so just as easy to check for to many. Might be better to have alternates sitting in the background. The php mysql approach would be to retrieve the _rowid_ from the form insert and set your php variable accordingly in your mysql statment. This way you can keep changing the number and keep all the old submission in the database table.

My simple approach would be this. After each entry is logged whether MySQL or a csv file a running count is compared. on the151 entry, that entry is erased and the person is directed to the page that Jo Ann suggested with a message saying I am terribly sorry but checking tells us the event is fully booked.
This would occur for any further submissions after that. So you would not have to monitor it and you would only have 150 although you could keep the numbers coming in and if you get a cancellation you have alternate members and for your record keep say a dozen in reserve.

The script is activated by the form redirecting to it. so each time there is an entry the script checks the total against what it reads in a file you can change. Then performs the top action deleting 150 plus a few.
You can say "you will be advised if there is a cancellation". Going further starts to be a tad more complicated.

Hmm! Back ends for the form builder, Have to think about it

Thanks all,
I will see what I can do with all the info here.
This may be something to add in the program for a future release.

Thanks again all

If you need assistance with it, I have most of the code if you save to csv. I do not use MySQL, I use a flat file system but that is another story. For 150 entries csv is fine can be downloaded to a spread sheet or Access. The script can be easily modified to suit what you are after.

Up to you I do not charge, you could not afford me if I did I get another version of a back end.

Prism ...I filled out the contact form at the site you gave me in another post but did not get a confirmation...I lost my harddrive on my computer and lost the email address I had from you last year.

The CSV option would be a great alternative. I haven't tried but I know Prism uses it. The csv option would allow an instant setup that is easily removed just by deleting the entire form with no need to setup databases. Great for limited data. I might have to look into this and get schooled by master P.