how can we automate the exportation of form data?

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

  • Profile Image
    allanftd
    Answered 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
    aytekin
    Answered 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
    khrisell
    Answered 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. :)