Is there a way to populate data from a MySQL database?

  • César Pérez
    Asked on March 14, 2018 at 7:20 PM

    I have an application that creates null registries with an int primary key to identify it so can we create a form and assign it an ID to later add response to a database?

  • Jan
    Replied on March 14, 2018 at 9:43 PM

    You may prepopulate the form fields via the URL, here's a guide: Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters.

    Currently, it is not possible to prepopulate the form fields from an external database.

    However, you can use the Spreadsheet to Form widget. This widget allows you to upload your spreadsheet to your form and use the values you have in the spreadsheet to pre-populate your form. Please check this user guide: https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget.

    Hope that helps. Let us know if you have any questions. Thank you.