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

    How to limit submissions in a form and display info already submitted?

    Asked by dpstreams on May 05, 2017 at 08:24 AM

    Here's my form:  https://form.jotform.us/71242946206151

     

    How do I create a sign up form for only 200 people, where it shows the 1-200 fields of name and email?  Then when the person fills out their name and email, it shows to others that 4 has signed up or 35 has signed up and it gives the next person #36 name and email fields to fill in. 

    Page URL:
    https://form.jotform.us/71242946206151

  • Profile Image
    JotForm Support

    Answered by Kevin_G on May 05, 2017 at 09:56 AM

    Yes, you could limit the number of submissions your form can receive, to do it, please follow this guide: https://www.jotform.com/help/137-How-to-Limit-Submissions-in-a-Form 

    You could also show a submissions counter on your form and let your users know the number of submissions already received: https://widgets.jotform.com/widget/submissions_counter 

    If you want to list the submissions on your form then you could create a report and embed it through an iFrame on your form, the following guide will help you with reports: https://www.jotform.com/help/326-How-To-Create-Form-Reports-in-JotForm 

    This widget will help you to embed the report on your form: https://widgets.jotform.com/widget/iframe_embed 

    And this guide will help you to add the widgets to your form: https://www.jotform.com/help/252-How-to-Add-a-Widget-to-your-Form 

    Hope this helps. 

  • Profile Image

    Answered by dpstreams on May 12, 2017 at 12:42 AM

     

     

    I was not very clear before so let me clear up more exactly what I am wanting in the form. Let me draw it out below.

     

     

    Additional Notes: So when the first person fills out his or her first name, last name, state or country, click submit, how do we set it up either automatically or manually, where the #1 person's first name, last name, & us state/country he/she entered shows up when #2 person goes to our site. What we want is for #2 person to see #1 first name, last name, & US state/country info, then #3 person see #1 and #2 info. #3 person can only enter the fields for #3.

     

     

    In other words, when the person click the submit button after completing the 3 fields, their info goes into the database and automatically popular back to the fields with their info so that it can not be changed and the next person can see the info. It's like first come first serve, and we want the next visitor to see the previous positions has already been taken so that they get the reality that spots are being filled quickly and therefore, give them urgency to act and commit.

     

     

     

    This is how I want the form to look (the lines represent the field boxes)::

     

     

     

    1. First name ___Kate____ Last name ___Jackson______

     

    US State or Country ________California________________

     

     

     

    2. First name _____John__________ Last name _____Doe______

     

    US State or Country _________Argentina__________________

     

     

     

    3. First name ____________________ Last name _________________

     

    US State or Country ________________________________

     

     

     

    ...on the way down to 40 of these

     

  • Profile Image
    JotForm Support

    Answered by candy on May 12, 2017 at 03:27 AM

    Hello,

    To my understanding:

    1. Firstly, you need to save your form submissions into your database as you can see in the following guide: https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP 

    2. After, you can use these submissions on your website with your own coding skills. 

    You are able to prepopulate the fields in the form as you can see in the following guide: https://www.jotform.com/help/71-Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters 

    However, you are not able to create the form elements dynamically in the form. For example, if you have 3 submissions in the database, you can not create all of the fields for these 3 submissions dynamically in the form. 

    Besides, you can embed a form submissions viewer application to your website in order to show previous submissions to your users as you can find it at the following link: https://apps.jotform.com/app/submission_view 

    However, this is not the format you have requested in your thread. You can only list all of the submissions on your website.

    I hope this information will help.

    Thanks.