Link Jotform to database on excel

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

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.