- Marc HouyouxAsked on April 07, 2017 at 02:18 PM
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
- SvenAnswered on April 07, 2017 at 03:29 PM
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:
If you would like to pass parameters to your form, please refer to this guide:
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.
- mhouyouxAnswered on April 10, 2017 at 11:45 AMThanks 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?
Emissions Inventory and Analysis Group
- JotForm SupportKiranAnswered on April 10, 2017 at 12:49 PM
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:
Hope this information helps!