Limit Submissions but Not Disable the Form

halh
Asked on May 17, 2012 at 07:55 PM

There are a number of variations on this theme. The original intent was to close a form based on previous number of submissions or date. I'd like to limit submissions within a field and display a message, e.g. "This course is full, you are on a wait-list" but still permit the other fields to be completed.

This is a re-post of a comment on How to Limit Submissions in a Form
jeanettebmz
Answered on May 17, 2012 at 08:38 PM

To my knowledge this is not possible to accomplish with Jotform.

However , some sort of workaround could be done to accomplish this, by sending your data via HTTP post ,or sending it to a Database and then compare data and display the desired message.

At any rate ,it would involve a deep task programming

Cheers!

Jeanette
abajan
Answered on September 13, 2012 at 03:45 AM

@halh

Pleased be advised that the Limit Submissions by Number and/or Date feature has been reimplemented. However, as my colleague has stated, the type of functionality you would like would require quite a bit of programming and as such, is unlikely to become a reality anytime soon. Nevertheless, one never knows what the future may hold.
halh
Answered on September 13, 2012 at 06:37 AM

Jeanettebmz, abajan,

In fact I've implemented the Export HTML and Google finance function suggested on the Jotform Forum to create an active summary sheet: (perhapslater, Sept 18, 2011) for class enrollment.

=ImportHTML("http://www.jotform.com/table/#########" &"?

workaround="&INT(NOW()/TIME(0;2;0))&REPT(GoogleFinance("GOOG");0) ; "table";1)

This sheet is constantly updated. I've added countif functions and conditional formatting alerts above the active spreadsheet to signal when enrollment-limited classes are full. This allows me to establish a wait list for those classes, contacting the enrollees as soon as their entry appears. (I cannot use the recently implemented Limit Submission feature as I don't want to disable the form for other entries when a class is filled.)

For now, I've abandoned an automatic response.
NeilVicente
Answered on September 13, 2012 at 10:13 AM

It's good to know you were able to find a workaround that fits most of your requirements.

Feel free to ask if you need help with anything else related to your forms and account.
zaki19
Answered on September 13, 2012 at 10:45 AM

saliiiiiiiiiiiiiiii