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

    Submitting form to a script file before going to Paypal.

    Asked by Mikey on September 18, 2016 at 10:01 PM

    Sometimes when working with Paypal, you need to submit the form data to a processing script file so that it can insert the custom information into a database and then have the script redirect to Paypal checkout page. Is it possible to submit information to a script file before going to Paypal with Jotform? Currently, I am using the Paypal wizard (on a WP site) -- which means the form data will be directed to Paypal upon submission. 

    submitting form a JotForm form data site wp
  • Profile Image
    JotForm Support

    Answered by Chriistian on September 18, 2016 at 11:22 PM

    Unfortunately it is not possible to direct the form to a script file before going to Paypal. You can only redirect to a different page after a payment has been made on the Paypal page.

    If you want to automatically redirect the form to a script file after submission, you will have to use the Paypal Pro integration. By doing so, your user can make the payment directly on your form so you can redirect them to a script file upon submission of the form. For more info about paypal pro, please follow our post here: Difference Between PayPal & PayPal Pro. You can also check out this guide for paypal forms: PayPal Forms

    If you need further assistance, please let us know.
    Regards.

  • Profile Image

    Answered by mikey213 on September 19, 2016 at 08:16 AM

    Thank you for your quick response.

    Just one last question: using just Paypal (not Pro), is there a way to store all of the form data in a database after the payment is made? Or, with Paypal, is Pro the only way for me to achieve getting all the data into a database after a payment is made?

  • Profile Image
    JotForm Support

    Answered by Rose on September 19, 2016 at 08:37 AM

    There are several ways to store submission data in an external database. These are listed here below.

    1. Using Send Form Post Data feature to add the data to your database indirectly but you need to write some PHP or other programming language server side code to insert the data to your database. 

    https://www.jotform.com/help/51-How-to-Post-Submission-Data-to-Thank-You-Page


    2. Exporting your form submission to an Excel file and import into your database. Following guidance assists you about how to export data to Excel.

    https://www.jotform.com/help/44-How-to-export-the-submissions-to-Excel-CSV-file

    3. Using Jotform Webhooks. This is in order to help you to transfer your data to your own database using your own script codes. 

    https://cms.jotform.com/blog/85-Send-Instant-Submission-Notifications-with-Webhooks

    4. You may also achieve it via Zapier. 

    https://zapier.com/zapbook/jotform/sql-server/

     5.Sending submission to your MySQL database using PHP. 

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


    6.Using sqlserver application. 

    http://sqlserver.jotform.io/

    If you have more questions, please feel free to contact us. We would be glad to help you. 

  • Profile Image

    Answered by Mikey  on September 19, 2016 at 10:00 AM

    Ooh, a bag of goodies! Hopefully, one of these links will help me. Thanks a bunch!