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 can I implement Condtional Statement to allow access to the form

    Asked by mryoung1906 on November 12, 2014 at 11:16 AM

    I want to put in names into JotForm so that if your name isn't in the system then you cant continue filling out the form. This is as a capacity of about 150 people.  I have the names on an excel sheet.

    excel sheet name smart forms conditional statemen
  • Profile Image
    JotForm Support

    Answered by jonathan on November 12, 2014 at 11:42 AM

    Hi,

    You can use Smart Forms using conditional statement that will allow the form respondent to proceed using the form if their Name is listed on the form.

    User guide: http://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic

    Example, you can add a Dropdown list on your jotform and the available option/selection in the dropdown list are the names of the 150 people that were only allowed to use the form.

    Once the form user selected their username, use conditional statement to allow the current user to move to the next section/page of the form.

    Hope this help. Inform us if you need further assistance.

    Thanks.

     

     

  • Profile Image

    Answered by mryoung1906 on November 12, 2014 at 11:59 AM

    Hello,

    I was going to do this method at first but I don't want everyone to see who is on the list. So I would almost need something like a search database.

    Please advise.

  • Profile Image

    Answered by raul on November 12, 2014 at 12:17 PM

    If you want to do a search in a database, then you'll need to enable POST data in your form to capture the name entered on the form and then you can use a web programming language such as PHP or ASP to run a query in the database to validate if the name exists and display the rest of the form upon validation.

    But you'll probably need to hire a programmer to achieve this, unless you are familiarized with web programming.

    If you have any questions, please let us know.
    Thanks.