Limit Submissions but Not Disable the Form

  • halh
    Answered 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.

  • jeanettebmz
    Answered 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 Support
    Answered 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.

  • halh
    Answered 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.

  • NeilVicente
    Answered 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.

  • zaki19
    Answered on September 13, 2012 10:45 AM

    saliiiiiiiiiiiiiiii