-
aklamotAsked on July 6, 2018 at 8:06 AM
Hello,
can I make form with calculation like this?
AC AD BC BD are prices depending on options selected before.
-
aklamotReplied on July 6, 2018 at 10:43 AM
Hello,
thanks for fast answer but my problem is little diffrent than what You think.
I dont want to add some values from questions or if question is answered yes/no.
Look at my screenshot above.
I want to have 8 possible calculation values.
-Question 1
Answer A
Answer B
-Question 2
Answer C
Answer D
-Question 3
Answer E
Answer F
And value of form will be calculated ONLY if user will answer 3 questions.
Possible answers
E-AC=484
E-AD=504
E-BC=823
E-BD=1017
F-AC=740
F-AD=1545
F-BC=1240
F-BD=1545
Do You understeand? ;) Is it possible to make?
-
BJoannaReplied on July 6, 2018 at 11:50 AM
If the values A, B,C,D,E and F do not have fixed values that you can use to assign calculation values to those options, you can use Update/ Calculate Field conditional logic to set the price.
How to Insert Text or Calculation into a Field Using Conditional Logic
Here is a demo form - https://form.jotform.com/81864419735972
Feel free to test it and clone it.
Hope this meet what you are looking for.
-
aklamotReplied on July 7, 2018 at 6:14 AM
Hey, thank You very much ;) I almost finished my form
https://form.jotformeu.com/81872021725353
But i still have problem with some options that should add value to allcalculations made before
Here is my final mockup. Could You help me finish this? Can i add fields like "Wzór numer ____" with field to write text? (it means Pattern number)
-
Mike_G JotForm SupportReplied on July 7, 2018 at 8:59 AM
I believe this can only be achieved using the "Other" option of the Single Choice field.
Please give me some time. I'll get back to you with an example.
-
aklamotReplied on July 7, 2018 at 9:08 AM
Could You please clone my form and try to add it?
https://form.jotformeu.com/81872021725353
I have 3 types more to configure
Type 1
Question 4 - if answer is second - than add 12 or 36 (depending on choice in question 1)
Type 2
Question 8 - if answer is first - than add 110
Type 3
Question 11 - add value of one of answers with quantity to write
quantity*value of one item=value to add
Your system looks friendly to use but my form is not easy and for my it is hard to set :/ When You show me examples i can understeand how it works but doing it myself if not easy for the first time.
-
Mike_G JotForm SupportReplied on July 7, 2018 at 11:31 AM
Question 4 - if answer is second - than add 12 or 36 (depending on choice in question 1)
After enabling the "Other" option of the Question #4
Please inject the custom CSS codes below to your form — How-to-Inject-Custom-CSS-Codes
input#other_7 + label:before {
content: "Wzór numer";
}
input#input_7 {
margin-left: 0px !important;
padding: 0px !important;
box-shadow: none !important;
border-color: transparent;
border-bottom-color: gray;
outline: none !important;
width: 40px;
}
To make the field look like this:
However, I'm afraid it would not be possible to fill in the "Other" box of the Single Choice field based on another field's answer. It can only be filled manually.
Question 8 - if answer is first - than add 110
To my understanding, you would like to add 110 to the value in the field CENA if the answer to Question #8 is the first one — which is "Tak".
In that case, I suggest that you set a Calculation Value for each option in Question #8.
Then, include the field in your conditions.
If the selected option in Question #8 is the first one then, 110 will be added to CENA. Otherwise, it will just be 0.
Question 11 - add value of one of answers with quantity to write
Here are the CSS codes you need for that field
input#other_15 + label:before {
content: "Tak - ilość";
}
input#input_15 {
margin-left: 0px !important;
padding: 0px !important;
box-shadow: none !important;
border-color: transparent;
border-bottom-color: gray;
outline: none !important;
width: 40px;
}
div#cid_15 span:first-child {
top: 27px;
position: relative;
}
div#cid_15 span:last-child {
top: -27px;
position: relative;
}
to make it look like this
Again, you need to enable the "Other" option of Question #11 just like what was instructed above for with Question #8.
However, with regards to this — "quantity*value of one item=value to add".
I understand that the "quantity" is the value that will be entered on the "Other" option in Question #11, however, may we know which option or field are you referring to with "value of one item", please?
-
aklamotReplied on July 7, 2018 at 6:03 PM
1. I have set value to answer "Tak" in question 8.
Then i tried to make this calculation (Równa się means is equal to)
But if field value is used to calculate the same field value calculation doesnt work for me. It shows some craz results.
https://form.jotformeu.com/81872021725353
It should be
Q1 A + Q2 A + Q3 A +Q8 A = 484 +110 = 594
But it is 10164
It works correct if i create another field with calculation but i dont want separate field :/ i would like to display all calculations value in one field.
"however, may we know which option or field are you referring to with "value of one item", please?"
Yes it should be constant value, in this case 0,5 so if someone will choose in question 11 - "Tak" and write eg. 54 then form should count 54*0,5 and add this value to CENA field.
-
Jed_CReplied on July 7, 2018 at 7:04 PM
Sorry, I'm just a bit confused with your calculation requirement. Just want to clarify if I have understood it correctly.
Where would I base the value for Q1 A, Q2 A, Q3 A? If you want all condition matching the Q1 A + Q2 A + Q3 A + Q8 A = 484 + 110 = 594 to be a fixed value if those combinations are selected, you'll have to create a separate condition for that combination only.
Ex.
You can check my cloned version here https://form.jotform.com/81876728249978 and see if the calculation works based on your requirement.
Looking forward for your response.
-
aklamotReplied on July 7, 2018 at 7:12 PM
Creating new separate condition for every combination would be insane :/ I would like to use separate condition only for first 3 questions but for others it would be easer to add values to questions 1-3 results. Can we maybe talk online for example on skype and can You help me set this?
-
MikeReplied on July 7, 2018 at 8:00 PM
I am sorry to inform you but the chat/remote session support is not available. This support forum is the best way to get in touch with us.
To sum the additional values you will need an additional form calculation widget field. You may try the next setup:
1) Populate the conditional calculation widget field with your calculation conditions.
2) Use one more form calculation field to calculate the additional options. Assign the calculation values, and then sum the fields.
Something like this:
3) Add one more calculation field to calculate the total amount.
Total = Conditional Calculation + Additional Options.
The fields that should not be displayed to the form user can be hidden.
-
aklamotReplied on July 9, 2018 at 5:14 AM
Hello, thanks againg for very good answers and You helped me a lot. But i have still some problem, it is hard to describe so i recorded video
Can You help me find bug why it shows bad results?
https://form.jotformeu.com/81872021725353
-
aklamotReplied on July 9, 2018 at 12:10 PM
Unfortunately it still counts wrong value
i recordet it here
-
BJoannaReplied on July 9, 2018 at 12:37 PM
Is the issue related to the form my colleague Benny_W provided?
https://www.jotform.com/81893858776986
If so, to resolve the issue delete the condition for the field "8. Pudełko na fotoalbum" like he suggested.
Here is my cloned form without that condition - https://form.jotform.com/81894626235970
Feel free to test it and clone it.
-
aklamotReplied on July 10, 2018 at 5:56 AM
Hey! Thank You all very much for help 😍 All works and counts values correctly. But i have only 4 small adjustments that would make form look better - can You help me too?
1. Slider on mobile version is scrached - images have wrong proportions. On desktop it looks good. Is there any settings for mobile that i have set wrong?2. Can i make this look like this?
3. In questions 11, 12 after messing with CSS and other option i have problme on mobile version. Second option "Nie" is covered.
4. And last idea that would be very usefull. I would like to make Field "Koszt (zł)" visible all the time when scrolling page - Because it is price and it changes during changes in form.