Dynamic dropdown and Spreadsheet widget

Pull a value from a web service to use as:

   - the label for a form box

   - widget spreadsheet value

   - a pull-down list for a user to select a value to complete a form

 

I'm not sure if I understand your question properly, we do have a spreadsheet widget that you can make use of, please find it here. We also do have a dropdown element in our Form Builder, as well as a Dynamic Dropdown widget. You can also use conditional logic to use the value in other fields in the form, more information about conditional logic can be found in the link below:

Smart Forms Using Conditional Logic

 

If you would like to pass parameters to your form, please refer to this guide:

Prepopulating Fields to Your JotForm via URL Parameters

 

I hope this answers your question, if not, then please get back to us with more details so we can understand your question better and assist you further. 

 

Thank you.

Thanks for your quick response. The information that you provided is helpful.
What I’d like to be able to do is to provide a dropdown list to select a value based on values returned by a web service. The particular web service that I would like to use is to get a list of NAICS codes. The documentation for the web service is available at http://www.exchangenetwork.net/schema/NAICS/1/NAICS_Web_Services_Developers_Guide_v1.0.docx.
On page 8, you can see the URL example 1 in Exhibit 4.2. The result of this call is a list of all NAICS codes for the given code set year. Would I be able to populate a dropdown list in Jotform using a list provided by the URL?
Also, would I be able to have the URL called be dependent on other data fields in the form (for example, the year needs to be specified, and so is there a way to have the URL be manipulated based on other parameters entered on the form?
Thanks,
Marc
----------------------------------------------
Marc Houyoux
Group Leader
Emissions Inventory and Analysis Group
EPA/OAQPS/AQAD
919-541-3649
...

Unfortunately, it is not possible to populate the list of a dropdown from an external source. However, you may be able to achieve this by writing a custom program and use the source code of the form. You may download the full source code of your form by following the guide below:

https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form

Hope this information helps!