halhAnswered on May 17, 2012 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.
jeanettebmzAnswered on May 17, 2012 08:38 PM
To my knowledge this is not possible to accomplish with Jotform.
At any rate ,it would involve a deep task programming
abajan Jotform SupportAnswered on September 13, 2012 03:45 AM
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.
halhAnswered on September 13, 2012 06:37 AM
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.
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.
NeilVicenteAnswered on September 13, 2012 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.
zaki19Answered on September 13, 2012 10:45 AM