How can I implement Condtional Statement to allow access to the form

  • Profile Image
    mryoung1906
    Asked 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.

  • Profile Image
    jonathan
    Answered 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
    mryoung1906
    Answered 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
    raul
    Answered 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.