-
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.
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 Jotform SupportAnswered on September 13, 2012 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.
-
halhAnswered on September 13, 2012 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.
-
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
saliiiiiiiiiiiiiiii