- paul levinAsked on April 13, 2016 at 11:24 PM
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?
- JotForm SupportEltonCrisAnswered 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.