How can I send submission data to my database

  • creaturedd
    Asked on December 14, 2017 at 2:38 AM

    I want to send my data and files uploaded through jotform into a database.

    Please suggest a way to do this which doesnt involve coding.

  • Support_Management Jotform Support
    Replied on December 14, 2017 at 5:50 AM

    The only other way of sending data to your database without coding is to use a 3rd party platform like Zapier to bridge this gap.

    Since you never mentioned what kind of database you're using, I'll just point you to some links from Zapier that might help:

    https://zapier.com/apps/jotform/integrations/mysql

    https://zapier.com/apps/jotform/integrations/sql-server

    Other than that, you would need to hire a developer that will come up with a PHP/MYSQL script to pass your submission data to your own database.

    Related guide: How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP 

    Alternatively, you can export your submission data to a CSV format, then import it to your database. The only downside is that this isn't automatic and has to be done manually on a regular basis to keep your database updated 

    Related guide: How-to-Download-Form-Submissions-as-Excel-CSV-PDF 

  • Support_Management Jotform Support
    Replied on December 15, 2017 at 4:05 AM

    Your reply didn't post in our forum so I'm pasting it here:

    Hey 

    Thanks for the reply. 

    I have a form through which my client will input some information and upload few files. I want to send the info and those files to a database in which I can view those documents 

    I was thinking of sending the data to access database.

    Or is there anyway I can link the database to Share Point link on which I will publish the form? 

    If it's going to be with Microsoft Access or Sharepoint, you still need to manually do this everytime. Your general workflow would be:

    1. Export your submission data to Excel

    2. Import the Excel Sheet to either Access or Sharepoint

    Related articles:

    Exchange-copy-import-export-data-between-Excel-and-Access

    Load-excel-data-into-a-sharepoint-2013-list-fast-and-easy