Dynamic dropdown and Spreadsheet widget

  • Profile Image
    Marc Houyoux
    Asked 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


  • Profile Image
    Answered 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:

    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.

  • Profile Image
    Answered on April 10, 2017 at 11:45 AM
    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?
    Marc Houyoux
    Group Leader
    Emissions Inventory and Analysis Group
  • Profile Image
    Answered 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!