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 we automate the exportation of form data?

    Asked by mcurley on November 07, 2011 at 10:49 AM

    We want to create a survey and automatically push the survey data to SQL or Excel (don't want to manually export the data.)

    Page URL:
    notcreatedyet

    automate data export form data survey excel sql
  • Profile Image

    Answered by allanftd on November 07, 2011 at 11:14 AM

    Hi mcurley,

    Thank you for your inquiry. 

    While there is no direct solution available at the moment, it is possible to indirectly integrate your JotForm form submissions into your database in a number of ways:

    A) Use the Send Form Post Data feature to add the data to your database indirectly. You will need to write some PHP (or other programming language) server side code to insert the data to your database. 

    B) Export your form submissions into an Excel/CSV File and import it into your database. For instructions on how to export submissions in JotForm,please click here.

    C) Google Docs integration - You can automatically set up JotForm HTML table report to update automatically into a Google Docs spreadsheet. Then, you can export Google Docs spreadsheet into an Excel sheet. 

    D) Purchase the JotForm Application License.  This way you can have complete control over your data.  You can also customize the source code according to your needs. 

    We hope you find this information useful. If you have any other questions or concerns , please let us know. Thank you for using JotForm!

    JOTFORM SUPPORT

  • Profile Image
    JotForm Founder

    Answered by aytekin on May 07, 2012 at 01:02 PM

    UPDATE: We have now released integration with Google Docs:

    http://www.jotform.com/blog/57-Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-

    You can get your submissions directly in a Google Docs Spreadsheet. Please give it a try and if you have any further comments or suggestions, post it on the blog post comments. 

  • Profile Image

    Answered by khrisell on July 04, 2013 at 11:02 PM
    Greetings!

    We are happy to announce that we have released Jotform Webhooks,  this feature would replace Send Post Data + Custom URL Thank You Page workaround in order to help you transfer forms data to your own database using your own script codes.

    To know more about Jotform Webhooks, please click here.

     

    Thank you for using JotForm. :)