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.


  • Profile Image

    Pre-sales Form Questions

    Asked by Jamie Shiller  on August 14, 2015 at 04:21 PM

    I have two pre-sales questions for two separate forms.

    1) I need to create a form for auto insurance leads. As part of the form a user must select their car brand, car model, and car year.There are 7,000 combinations. Can I load a csv of all the choices into a form, then have the form show only the relevant car makes and years for a particular brand? So this involves to two things: conditional logic,and the ability to import a big list of choices. Is this capability available? 

    2) I need another form that lets a user input a zip code. The user will be sent to a subsequent web page if it matches a list of acceptable zip codes, if not the user will see an error message. So similar to my first question, here I need to be able to import a list of acceptable zip codes. Is this possible?

    Thanks,

    Jamie

    CSV message create choices
  • Profile Image
    JotForm Support

    Answered by mert on August 14, 2015 at 05:56 PM

    Hi,

    For the first part of your question, yes you can import CSV data into JotForm. Here is the clear instruction for this action :

    https://www.jotform.com/help/308-Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm

    For the second part of the question, yes you can add conditions to dropdown selections. Unfortunutely, I don't have big CSV data, but I prepared a sample for you to see the system's work,

    http://form.jotformeu.com/form/52257106175351

     

    Lastly, your second question has almost the same feature and you can redirect your users to different pages depends on their zip codes. For the zip codes data, you can upload them to JotForm just like the previous question.

    If anything is not clear for you, please feel free to contact us.

     

    Mert

  • Profile Image

    Answered by Jamie  on August 14, 2015 at 06:59 PM

    Great answer. Thanks!

    In your example, the third option shows only when selecting the first two options. Is it possible to

    show the drop down for the third option even if it doesn't have data in it yet? I ask because the appearance of another fields affects the layout.

    Thanks

  • Profile Image
    JotForm Support

    Answered by Welvin on August 14, 2015 at 09:06 PM

    Hi Jamie,

    Yes, that is possible. You just need to change the conditional logic to show a model dropdown by default. For example:

    http://www.jotformpro.com/form/52258543997975 

    Or, try using our Dynamic Dropdown Widget: http://www.jotformpro.com/form/43514646570961. The way how I understand your question, this widget should give you the option to show other options based on the first dropdown without adding too many conditional logic. Imagining that you have 7, 000 combinations.

    Thanks

  • Profile Image

    Answered by Jamie  on August 17, 2015 at 05:34 PM

    Great examples. Thanks!

    I need to be able to get an html embed of the form code so I can paste it into my site and style it. Is that possible, and will the dynamic options work if I use an HTML embed?

    Thanks,

    Jamie

  • Profile Image
    JotForm Support

    Answered by Welvin on August 17, 2015 at 06:42 PM

    Hi Jamie,

    The widget is embedded in the source codes and I'm afraid that there's no way you can style it if you will use the source codes method (https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form). You will have to style the Dynamic Dropdown widget using its own CSS style area:

     

    But why you would need to use the source codes if you can style it using our Designer (https://www.jotform.com/form-designer/)?

    Then you can just embed the form using our default embed method or iframe so everything you'll make a changes in the form builder, you don't need to redo the styles in the source again.

    Thanks