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

    How can I connect a JotForm to an external database or spreadsheet?

    Asked by digonline on April 01, 2017 at 09:54 PM

    Hi JotForm

    Sorry for what might a dumb question.

    Is there anyway to connect a JotForm to an external database and/or an excel spreadsheet to pre-fill out some fields based on what is entered?

    Is there an API or some other integration?

    Please advise.

    Thanks,

    Don

  • Profile Image
    JotForm Support

    Answered by Jan on April 02, 2017 at 07:47 AM

    It is possible to send the form submission to your own MySQL database using PHP. Please refer to this guide: How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP.

    You might also want to check JotForm Webhooks. Here's a guide: How-to-Setup-a-Webhook-with-JotForm.

    Unfortunately, it is not possible to use external values or database and populate the form fields. You need to manually enter the values and create multiple Update/Calculate Field conditions in your form. We do have an app called Field Prepopulator. Please refer to this link: https://prepopulate.jotform.io/.

    We have an API documentation that you might want to check. Here's the link: https://api.jotform.com/docs/

    In the API documentation, you'll see GET or POST submission. You can probably use this to retrieve submission data. Here's the URL: https://api.jotform.com/docs/#submission-id.

    Hope that helps. Thank you.