How do I export submissions to a database?

  • Ubbo48
    Asked on March 13, 2018 at 11:42 AM

    I need to output fields of a form to excel. Surely that is standard.

    But also standard is that all forms of a repeating section are placed in the same row. This is not clever when one wants to export to a database, e.g. MS access.

    So the excel sheet should reflect the layout of the form.


    Question 1 AAAAAAAAAAAAAAAAAAAAAAAAAA

    Question 2  BBBBBBBBBBBB

    Repeating SSSSS TTTTTT  RRRR QQQQQQ
                   YYYYYY                ZZ  PPPPPPP


    should lead to in excel

    AAAAAAAAAAA BBBBBBBBBBB SSSS TTTTTT RRRR QQQQQQ

    AAAAAAAAAAA BBBBBBBBBBB YYYYY           ZZ     PPPPPPPP


    Can you show me how to achieve that?


    Regards


    Ubbo



  • John_Benson
    Replied on March 13, 2018 at 1:21 PM

    To export form data to Excel, please follow this guide: https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel

    You can also integrate your form to the Google Spreadsheet. It automatically transfers form data to the Spreadsheet everytime someone submitted to your form. Here's a guide: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    Please try it and let us know how it goes. Thank you.


  • Ubbo48
    Replied on March 14, 2018 at 5:01 AM

    Thanks John,

    Your answer does not touch the essence of my question. As I wrote, the standard export to Excel that you link to, is not what I want. May be I should have stated the question more clearly:

    I do not want to have all answers of a respondent on a single line in Excel. I should like to have all answer lines of the form in a separate line in Excel

    Can you comment on that?

    Thanks


    Ubbo

  • Victoria_K
    Replied on March 14, 2018 at 8:50 AM

    As far as I understood the idea, it seems to be not possible to modify the layout of an Excel Report. We only have export options "questions as columns".

    But, as you've mentioned exporting to a database, I can suggest you to send the data using Webhooks integration:

    Send-Instant-Submission-Notifications-with-Webhooks

    Or to push the data directly to your database:

    How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    The process would be just like in the link above, but instead of inserting it to MySQL Database you will insert it to MS Access database.

    It might be of help also to check the list of our available integrations as to "database":

    https://apps.jotform.com/search/database


    Hope this information helps! But, let us know if you need any other assistance as to your JotForms.