- Jamie ShillerAsked 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?
- JotForm UI DevelopermertAnswered on August 14, 2015 at 05:56 PM
For the first part of your question, yes you can import CSV data into JotForm. Here is the clear instruction for this action :
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,
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.
- JamieAnswered 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.
- JotForm SupportWelvinAnswered on August 14, 2015 at 09:06 PM
Yes, that is possible. You just need to change the conditional logic to show a model dropdown by default. For example:
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.
- JamieAnswered 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?
- JotForm SupportWelvinAnswered on August 17, 2015 at 06:42 PM
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.