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.
Link Jotform to database on excelAsked by ssonter 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.
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.