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

    Restrict who can access to form

    Asked by paul levin  on April 13, 2016 at 11:24 PM

    Hello,

    We have a small membership organization (300 members).  I would like to create about a dozen forms the members can access and use for free.  Non-members would not have access to them.  Is this possible?  

    That was question 1.  Question 2 is this -- can I have a form, let's say a daily report, that gets assigned a number each time one is filled out.  For example, today would be No. 1, tomorrow No. 2, etc.  I.E., the report number gets automatically incremented by 1 each time the form is completed and emails.

    Question number 3.  Can the data put on a form also be transferred to a spreadsheet, or database maybe?

     

    Thnaks.

    Paul

  • Profile Image
    JotForm Support

    Answered by EltonCris on April 14, 2016 at 01:11 AM

    1. We do not have password protection on the form so I suggest implementing the password protection feature on the page where you will embed the form. So whoever has the password will be able to access the page where the form is embedded.

    OR, you may want to consider this workaround https://www.jotform.com/help/306-Allow-Jotform-to-Be-Filled-out-Only-by-Those-with-a-Special-Link

    2. That's possible using Unique ID widget. Guide: http://www.jotform.com/help/79-Add-Custom-Unique-IDs-to-your-Form-Submissions

    3. Yes, that's possible. Here's how to download your form submissions into Excel, CSV or PDF. http://www.jotform.com/help/73-How-to-Partially-Download-Form-Submissions-to-Excel-CSV-PDF

    If you want to send form data to your MySQL database, here's how: http://www.jotform.com/help/126-How-to-Insert-Update-Submissions-to-Your-MySQL-Database-Using-PHP

    FYI, since you have multiple questions on this thread, we might split each question into a separate thread if you have any follow-ups of these three. We also suggest to post one question per thread next time. Thanks for your understanding.