Understand data integration mechanism

  • Profile Image
    Tommaso Lucentini 
    Asked on October 29, 2020 at 11:04 AM

    Hello!
    I'm writing to understand how Jotform would integrate with our business model.

    We run a company where we need to fully customise our surveys to make it work with our features.

    To understand if Jotform could be for us, I'd like to know some of those information.

    1) Can we keep our data private on our physical proprietary database? Due to the confidentiality of our activities we need to keep everything private.

    2) Can we customise it to have pre-definite responses based on the data we currently have about our respondents?

    3) Can we link any tag to questions in order to populate our database?

    Thanks a lot in advance for your questions!
    Kind regards,

    Tommaso


  • Profile Image
    Sam_G
    Answered on October 29, 2020 at 12:34 PM

    Hi Tommaso,

    Thank you for contacting Support.

    1) Can we keep our data private on our physical proprietary database? Due to the confidentiality of our activities we need to keep everything private.

    Please note that when the form is submitted, the submission data is captured on the form's submission page. You may like to take a look at the following guide on how to view your submissions data: https://www.jotform.com/help/269-How-to-View-Form-Submissions

    If you want to send your form's submission data to your own database you can take advantage of the POST method. The following guide should help you: http://www.jotform.com/help/126-How-to-Insert-Update-Submissions-to-Your-MySQL-Database-Using-PHP

    2) Can we customize it to have pre-definite responses based on the data we currently have about our respondents?

    Though you can take advantage of our "Import Data" app to import data from the database to your form submission page. However, it is not possible to populate the field of your form from any external data source or from your form's previous submissions.

    One possibility is to write a new page which will fetch the data from DB and then populate the form field by taking advantage of our "URL Parameter" feature.

    The following guide should help you:  Prepopulating Fields to Your JotForm via URL Parameters

    You may also use the Spreadsheet to Form widget. This widget enables you to upload an excel file that houses all the options. It acts like an auto-fill or like querying a database using a unique code. To know more about it and how to use it, please check out this guide:

    How-to-Use-the-Spreadsheet-to-Form-Widget

    3) Can we link any tag to questions in order to populate our database?

    With a Unique ID widget, you can get unique autoincrement numbers.

    Let us know if this meets your requirements.