Link Jotform to database on excel

  • Profile Image
    ssonter
    Asked on January 12, 2017 at 06:48 PM

    Is it possible to upload a database of locations on excel so that the user can select from the list or do these have to be added individually as a drop down box?

    The selection is to service tickets for our customer for functionality we would like to integrate the form with the database.

     

    Thanks

    Sharon

  • Profile Image
    liyam
    Answered on January 12, 2017 at 10:43 PM

    Hello Sharon,

    If I'm understanding correctly, you want your excel spreadsheet to be the source of information as a dropdown list on your form, is this correct? If so, this is not possible since the information coming from the dropdown on a form are static. Meaning it has to be added manually. Also, an Excel spreadsheet is not possible to use online as a source of record from another. Although it is possible if done in a local area network, but not on the internet.

    Instead, if you have an online database situated in a web host (such as MySQL, MariaDB, MS SQL), you can add or insert the information there, modify your Jotform to have a little bit of coding and you an use the online database as source. But you will need to place your JotForm-based form on a website changing it's full HTML source (not embedded).

    You can get your form's full HTML source code by following the steps here: https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form

    If you have questions and clarification, or if I'm misunderstanding your inquiry, please let us know.