What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Limit Submissions but Not Disable the Form

    Asked by halh 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

  • Profile Image

    Answered by jeanettebmz 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

     

  • Profile Image
    JotForm Support

    Answered by abajan 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.

  • Profile Image

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

  • Profile Image
    JotForm Support

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

  • Profile Image

    Answered by zaki19 on September 13, 2012 at 10:45 AM

    saliiiiiiiiiiiiiiii