How can I use conditional logic to adjust pricing total?

  • mbernhardt
    Asked on August 20, 2015 at 3:52 PM

    My form has multiple options for workshops for people to purchase. The last option is to save money buy purchasing all 8. I would like it if when this option is selected, the total will reflect that amount only, rather than adding it in with other options which may have been selected. I tried using Update a Field Form Value to reflect the correct total if that's selected, but then the other options are always ignored. I'm probably doing it wrong and help would be appreciated.

    Another option is if there was a way to have all other checkboxes automatically uncheck if the last one is selected, but I don't think that's possible.

  • TitusN
    Replied on August 21, 2015 at 1:36 AM

    Hello,

    I took a look at your form - I could be wrong, but I think the following is true: 

    1. If the last option is selected (Register for all 8 and get one free!), it would be equal to selecting all the previous 8 checkbox options , with a discount of either $30 or $25 (depending on whether we are talking about HaaS pricing or not)

    2. The last option should work independently, should be separated from the other options (meaning that the discount should only apply if all the options are checked)

    My suggestion: 

    Why not remove the last option(s) altogether, and automatically effect the discount if all the options are checked? - You can use the update conditional logic to do that: 

    How can I use conditional logic to adjust pricing total? Image 1 Screenshot 20

    You can add some text on your form indicating that a discount is applicable if all options are purchased. 

    Does that help? Please let us know.

     

  • mbernhardt
    Replied on August 21, 2015 at 11:33 AM

    It's a great idea, but it doesn't seem to work. If I add that logic, things get very erratic- the options which are added to the logic don't post pricing when they're selected individually. And if one DOES select all 8, the total posted is the conditional amount plus one workshop!

    Could you do a mockup and check it out yourself, or is there a way I could post my actual form somewhere for debugging? I've removed that stuff from it for now because we will want to be using it in the next day or 2.

  • BJoanna
    Replied on August 21, 2015 at 2:17 PM

    You could achieve that you adding one more field to your form. Let's name it "Discount" field. Then you can use conditional logic to update a form field value and set conditions like this.

    How can I use conditional logic to adjust pricing total? Image 1 Screenshot 40

    How can I use conditional logic to adjust pricing total? Image 2 Screenshot 51

    So if all 8 check boxes are selected add 30 inside of Discount field.

    You also need to add Discount field inside of your calculation. 

    How can I use conditional logic to adjust pricing total? Image 3 Screenshot 62

    Also I would suggest you to remove last check box option. You can add text field to notify your users that if they select all options they will get a discount.

    I have add mentioned conditional logic only for Select Workshops field. Also I have set all fields to be visible so that you can see calculations. 

    Here is my demo form: http://form.jotformpro.com/form/52325082137954? 

    Feel free to clone my form if you want to take a closer look to condition that I have set. 

    Hope this will help. Let us know if you need further assistance.