Conditional form fields based on selection

  • Profile Image
    bigelito
    Asked on August 11, 2019 at 10:17 PM

    Hello. I've got a form that I'm using to create part requests for 1500 stores. What I would like to do is when the user selects the Store Name and City, it auto populates the address and phone number for that specific store. I have all of this data in a separate excel file, so my question may be twofold as I'm wondering if I can import this file into Jotform?


    Thank you!!

  • Profile Image
    Victoria_K
    Answered on August 12, 2019 at 02:25 AM

    Hi!

    We have a Spreadsheet to Form widget. It allows to attach an excel file to a form. The form should be then populated based on unique code user enters. That code you could generate by combining values of Store Name and City. Form Calculation widget should be of help to do that. 

    Please review the help guides I'm linking below:

    How-to-Manipulate-Text-String-with-Conditions-and-Calculation

    How-to-Use-the-Spreadsheet-to-Form-Widget

    We will be glad to assist if you need more help, just let us know. 

  • Profile Image
    bigelito
    Answered on August 15, 2019 at 02:27 PM

    The spreadsheet to from widget seems to be limited to specific field names.

    I have changed my fields to have a Dropdown of "City" and then a Dropdown of "Account".

    I'd like to:

    When the user selects the "City", it filters to show only the "Account"(s) in that city. (This isn't a necessity but would be nice).

    More importantly, once the user selects the "City" and "Account" the "Address", "Province", "Postal Code" and "Phone Number" auto populate.

    Here is a screenshot example of the master excel file:

    What are my options, here?


    https://www.jotform.com/build/92055489658270

  • Profile Image
    jonathan
    Answered on August 15, 2019 at 03:41 PM

    I have responded to your separate post about this here https://www.jotform.com/answers/1928412 

    You may update us on that thread instead.

    Thank you.