How to calculate a total value with discount, based on products and drop down selections?

  • Profile Image
    GrannyGooGoo
    Asked on February 13, 2016 at 03:55 PM

    I just wanted to update my earlier problem. I was trying to use the conditional statements to update prices if a certain box was checked but couldn't figure out how to adjust it for all the different prices. Since last night I figured out that I had to make a statement for each price and it worked. Was a pain to write a statement for each one, hopefully it will work as intended.



    This is a re-post of a comment on Smart Forms Using Conditional Logic

  • Profile Image
    Kevin_G
    Answered on February 13, 2016 at 11:19 PM

    Yes, you need to set one condition for each selection in your form.

    I checked your form and I can see it's currently working, if you have some issues, you can indicate us the problem, we will be glad to take a look on it and help you.

  • Profile Image
    GrannyGooGoo
    Answered on February 15, 2016 at 03:56 PM

    Thank you for your answer but when I try it the price gets added to the total where it should be yet the discount for local pickup does not get calculated. I don't know what I am doing wrong. Any suggestions will be helpful, in the meantime I will try rearranging some things to try to get it to work.

    Thanks

  • Profile Image
    Kevin_G
    Answered on February 15, 2016 at 05:12 PM

    I have checked now your form and I can see that you have added some conditions to update the total amount in your form.

    I have tested it and I see that it's working as expected.

    If  "Local Pickup or Delivery" is equal to "Local" and "Order and Payment" is equal to "Medium" then the result in the field "Total for Order Today" should be 300, because based in your condition, you are taking the total value for "Medium" which is $600 and then you subtract "350", so this is the operation: 600 - 350 = 300.

    Did you found the solution for your calculation? 

    Do let me know if I misunderstood your question, we will be glad to take other look to your form.