JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
How Do I Get Selected Options in a Drop Down to Populate Multiple Calculation Fields With Different Values?Asked by Driftcenter on March 25, 2015 at 04:13 AM
I wonder if there is a way to split up/show selected texts from a drop down field.
I have several options in the drop down menu, like:
And i have figured out how to show one result in a calculation field by using the calculation values in the drop down menu. But i want to show several options in several calculation fields that all linked from one drop down menu.
Please have a look at this demo. If that's the functionality you wanted, there are a couple of ways to achieve it. Here's the method used in the demo:
1. Insert the following calculation values into the drop down's properties:
2. For the first calculation field (Calc1) just add the drop down field:
3. For Calc2 and Calc3, "Update a form field value" conditions would need to be created:
For Calc2, create the following condition:
4. Create three (3) additional conditions like the above but change the "A" to "B", "C" and "D" respectively
5. Four similar conditions would need to be created for Calc3. The only difference is that the expression would contain the letter "B" instead of "A":
When you're done there should be eight (8) conditions in total:
That's pretty much it but if you need further assistance with this, please inform us.
Incidentally, in case you're wondering about the other method, it's this: Don't put any calculation values in the drop down and then create twelve (12) conditions, similar to the following:
But that would be more tedious.
By the way, please feel free to clone the demo if anything above is unclear.
I cannot find the option " Conditions wizard " in calculation field. How can i do it ? Thx
You can find the Conditions Wizard in the calculation field by clicking on the Wand Icon seen in the screenshot below:
You have sent me screenshots for "calculation wizard", bit in previous posts in actual thread your colleagues put screeshots with "conditions wizard" . I mean " conditions wizard" not " calculation wizard" . Thx in advance.
In my colleagues sample, Abajan uses 3 calculation fields to display the result of what is selected in the dropdown. It is not possible to populate a dropdown with values, depending on what is selected. If this is not what you are looking for, you may always view the DYNAMIC DROPDOWN widget. This will enable to create various dropdown and only display the the corresponding one, depending on the selection. It does not calculate values, but if the results are not dynamic this might be useful.
Ok, I see. Thx. But how one can assign to different countries the corresponding shipping zones for various carriers ? By defaulut, "dropdown" field with "special options " - countries allows assigning only 1 set ot values. For my case, the values of countries will be shipping zones for different carriers. Every carrier has separate shipping zones numbering. So what i mean, the customer select the country from dropdown and 3 additional calculation fields should be enabled/ showed with separate shipping zones number (tarifs) for corresponfing carriers predefined values set.
Or, I 'd refolmulate the problem. Is it possible to simultaneously select the same option (country) from a few different dropdowns ?
I mean that every dropdown with "Countries" option will be manually prepopulated by corresponding set of values (shipping zones for carriers). Customer select on web form the country from dropdown and for example 3 calculation fields will be showed - for TNT, UPS and DHL.
Or may be there is any "trigger field" one can use for that ? Thx
If I understand you correctly, you have added a address field in your form. Depending on the country the users selects, you would like to show the different carriers that country has.
I may be getting ahead of myself, but I created a small form in witch a users selects a country and a dropdown appears will all the carriers. Once the users selects a carrier, the total will automatically be updated.
You may clone the form and review it as you like.
Please let us know if this helps.
Thank you Viktor. The problem is that the output calculations filed should be calculated simultaneously for selected country. The all set of freight prices should be showed simultaneously, so the customer can visually compare freight . Your sample form assume that I have to create about 200 x 5 x 4= 4000 conditions ( for every country multiply weight intervals x multiply number of carriers). The problem is that when i am going to create more as 5 conditions for dropdown with countries - the form freezes. For that i opened the another ticket whicht was forwarded to developer. http://www.jotform.com/answers/757875-Conditional-Logic-Multiple-IF-statements-on-Address-field-causes-the-form-builder-to-lag-freeze#7
You do not really require to create 4000 conditions. You just need to create a single condition for each country. This is not a very complicated condition like you have in your other thread. This will only verify one field and not more.
This condition will display the corresponding radio button will all the carriers. and also display the total (if required). In each radio button I have again placed a calculation value that can be jused to calculate the require total.
I have adjusted the form again with these changes. You may use the same link to clone the form.
Please let us know if this helps.
Can this form that you are referring to: http://form.jotformpro.com/form/50834042022946 be done with 3 inputs? In other words, 3 different drop downs and depending on the selections the 3 outputs are calculated? (I already have the calculations for each possible scenario)?
Thank you so much