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

  • dpstreams
    Asked on May 5, 2017 at 8: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. 

  • Kevin Support Team Lead
    Replied on May 5, 2017 at 9: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. 

  • dpstreams
    Replied 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

     

  • candy
    Replied on May 12, 2017 at 3: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.