How can I export the tables so I can build it in our SQL server?

  • Profile Image
    jaykapalczynski
    Asked on June 06, 2016 at 05:37 PM

    Export Tables?

         In a more simple terms exporting of the Excel file I can build my tables in SQL Server but its missing the entire Schema.  How does this work in regards to Web-hooks.  Does one create the fields in their own SQL Server and then Web-hook from Jot Form to the SQL Server

  • Profile Image
    Welvin
    Answered on June 06, 2016 at 05:54 PM

    In your first question, I gave you the guide on how you can send your form submissions to SQL Database using PHP. As well as the Webhook method. Here are the links again:

    https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    https://www.jotform.com/help/245-How-to-Setup-Webhook-with-JotForm

     

    How does this work in regards to Webhooks.

    If you are going to do this using Webhook, you need to code it and integrate it in the form. You can use a third party to do this, to make it simple to do. Example, through Zapier: https://zapier.com/zapbook/jotform/webhook/

     

    Does one create the fields in their own SQL Server and then Web-hook from Jot Form to the SQL Server.

    Yes, you should have the tables ready on your SQL server regardless of what method you choose above. 

     

    Let us know if you have a follow up questions regarding this matter.