- John FoleyAsked on July 21, 2014 at 02:02 PM
A few questions:
-- Can a form be created on your hosted site that saves data to a sql database in our computer system?
-- Can a form be created that saves data to a database in your hosted system and then can a user maintain that data?
-- Can a form be created on your hosted site that prompts for username and password before allowing a user into that form?
- JotForm SupportWelvinAnswered on July 21, 2014 at 03:00 PM
We usually split questions to a new thread, but let me answer you general questions here;
1. We don't have a direct feature for forwarding form submissions to SQL Databases, but you can use Zapier-Jotfor-MSSQL integration. Get it here: http://zpr.io/RWre.
OR, you can also export your form submissions in MSSQL format and manually import it to your database: http://apps.jotform.com/app/ms_sql_server_export
2. I'm not sure what you mean by this. Are you trying to give the user the ability to submit the data and come back to it later to edit. If yes, this guide would help you accomplish that: http://www.jotform.com/help/40-How-to-Let-Users-Update-Their-Form-Submissions-at-a-Later-Date.
3. Still, we do not have a direct feature that would accomplish this one. A workaround would be using our conditional logic, and create a key combination that serves as the access to the form.
For example: http://www.jotformpro.com/form/42015843398963 (Enter 11 and 22 accordingly).
Let us know if you have further questions.