How to set prices depending on answers from multiple questions

  • aklamot
    Asked 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.

    Jotform Thread 1517625 Screenshot
  • aklamot
    Replied 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?

  • BJoanna
    Replied 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. 

    1530891851condition2 Screenshot 10

    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. 

  • aklamot
    Replied 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)

    1530958292albumy3 Screenshot 10

  • Mike_G JotForm Support
    Replied 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.

  • aklamot
    Replied 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 Support
    Replied 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

    1530975244t10 52 59 Screenshot 10

    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:

    1530975162t10 52 20 Screenshot 21

    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.

    1530975901t11 04 17 Screenshot 32

    Then, include the field in your conditions.

    1530976097t11 06 44 Screenshot 43

    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

    1530977293t11 27 58 Screenshot 54

    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?


  • aklamot
    Replied on July 7, 2018 at 6:03 PM

    1. I have set value to answer  "Tak" in question 8.

     15310001351530975901t11 04 17 Screenshot 10


    Then i tried to make this calculation (Równa się means is equal to)

    1531000200Screen Shot 2018 07 07 at 23 Screenshot 21

    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_C
    Replied 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.

    1531004492The Easiest Online Form Builde Screenshot 10

    1531004571calculation value Screenshot 21

    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. 

  • aklamot
    Replied 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?

  • Mike
    Replied 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:

    How to set prices depending on answers from multiple questions Image 1 Screenshot 40

    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:

    How to set prices depending on answers from multiple questions Image 2 Screenshot 51

    3) Add one more calculation field to calculate the total amount.

    Total = Conditional Calculation + Additional Options.

    How to set prices depending on answers from multiple questions Image 3 Screenshot 62

    The fields that should not be displayed to the form user can be hidden.

  • aklamot
    Replied 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

  • aklamot
    Replied on July 9, 2018 at 12:10 PM

    Unfortunately it still counts wrong value

    i recordet it here

  • BJoanna
    Replied 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. 

    1531154049cond Screenshot 10

    1531154200test1 Screenshot 21

    Here is my cloned form without that condition - https://form.jotform.com/81894626235970 

    Feel free to test it and clone it



  • aklamot
    Replied 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?

    1531215628Screenshot 2018 07 10 11 38 55 Screenshot 10

    2. Can i make this look like this?

    1531215999Screen Shot 2018 07 10 at 11 Screenshot 21

    3. In questions 11, 12 after messing with CSS and other option i have problme on mobile version. Second option "Nie" is covered.

    1531216094Screenshot 2018 07 10 11 46 51 Screenshot 32

    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.

    1531216436Untitled 3 Screenshot 43