-
MiguelAsked on November 30, 2019 at 3:59 AM
Hello,
I already know how to show specific fields depending on previous answers.
But what I seek is to show always the same fields, but with different sets of answers depending on previous answers.
For instance: in the field 1 I ask for 'Mode', and the values are 'Red' and 'Blue'. Depending on this answer, I want the field 2 'Details' to show 'A', 'B', 'C' for 'Red', or 'M', 'N', 'O' for 'Blue'.
Is this even possible to achieve in Jotform?
So far, I have created two fields 'Details' with each set of answers, but the result is a CSV with three columns: 'Mode', 'Details' and 'Details', and obviously I want only two columns.
Please, if this is not possible to achieve in Jotform, could you tell me about any other app that does? I know this is quite against the idea of company, but I just don't seem to know how to query this in Google and I'm going crazy.
Thanks so much for your time!
-
Girish JotForm SupportReplied on November 30, 2019 at 8:31 AM
From what you have described this looks like a nested drop down approach instead of conditions.
Please try using the Dynamic Drop down widget and let us know if this works out for you - https://www.jotform.com/widgets/dynamic-dropdowns.
If not, we'll check for an alternate workaround.
We will wait for your response.
-
MiguelReplied on December 1, 2019 at 12:55 PM
Hi again,
Gerardw, thank you very much for your answer! That is almost it! It goes really close to what I pursue. But there's something failing:
When I introduce the dynamic drop-down, the shown values do depend on the previous answer. Great up to this!
But when I export the submissions into a CSV file, the fields are not exactly separated... All the values within the same dynamic drop-down are stored together. And if you select the comma as a separator in the widget (in order to easily separate them later in a quick treatment of the csv), it groups them all into a single string, between quotation marks (").
Example:
Dynamic drop-down:
Date
Red
.
A
B
C
Blue
.
M
N
O
Exported CSV:
Date,Mode
2019-12-01,"Red , A"
Still, a quick treatment of the CSV is possible and easy, and thus this solution would do. But I'd love to find a straight-forward solution! It must exist somewhere :-)
-
Mike_G JotForm SupportReplied on December 1, 2019 at 3:40 PM
Since it is not possible to hide options in a dropdown field based on another field option, we will use a 3rd "Details" field in your form that will have all the options from "Details" field 1 and "Details" field 2.
Details field 1 will only show on the form if Red is selected as Mode and Details field 2 will only show on the form if Blue is selected as Mode.
Now, whatever value is selected in Details 1 or Details 2, it will be passed to Details 3. Details 3 will be hidden on the form.
When generating the CSV file of your form submissions, which I assume you do it on the submissions page, hide Details 1 and Details 2 first. This way, only the Mode field and Details 3 will be on the CSV file.
Here's a Sample Form: https://form.jotform.com/93345787686982
The Details fields are just numbered to prevent confusion.
Here are the conditions used:
Please take note also that the Clear Hidden Field Values settings of your form should be set to "Clear On Being Hidden".
On the submissions page of your form, please hide Details 1 and 2 fields.
Then, the downloaded CSV file will only have the fields that are shown.
I hope this helps. Please feel free to let us know if you need any further assistance.