Adidng Values on Check boxes and Passing Value to Payment Total Field?

  • ballareinternational
    Asked on February 4, 2015 at 9:15 PM

    I want to set a payment value for each selection of events, and subsequently, tabulate the total cost and link it directly to the Paypal page for people to make payment of the total cost tabulated.

     

    Would appreciate your help. Thanks!

  • Charlie
    Replied on February 4, 2015 at 10:55 PM

    Hi,

    It seems that your conditions show a message "Field Deleted", could you kindly check and update them? We had a bug early this day that caused this problem, you can also try reverting back to an earlier version of the form using this guide: http://www.jotform.com/help/294-How-to-View-Form-Revision-History.

    For your question, I see that you are manually inserting values to a field, I would suggest that you just add values in your check box options so that you can later use them in your Form Calculation widget. Here's a quick guide.

    1. Click the check box field which will have pre-set values on them.

    Adidng Values on Check boxes and Passing Value to Payment Total Field? Image 1 Screenshot 60

    2. Inside the properties, add calculation values, add it in a way how the options are listed and separate each value by clicking "Enter" for a new line.

    So if you have a list of options like this:

    Option A

    Option B

    Option C

    The calculation values will also be like this:

    Value 1

    Value 2

    Value 3

    Of course if it's a calculation you just need to input a numeric value not with the word "value" on it.

    Adidng Values on Check boxes and Passing Value to Payment Total Field? Image 2 Screenshot 71

    3. After that, we want to capture that field and add all the values on the total cost, you need to edit your form calculation widget by clicking the wizard icon.

    Adidng Values on Check boxes and Passing Value to Payment Total Field? Image 3 Screenshot 82

    4. Here you can add fields and have them a total on all of them.

    Adidng Values on Check boxes and Passing Value to Payment Total Field? Image 4 Screenshot 93

    5. In your Payment wizard, choose the field where you will get the final cost. In this case we want to get the value from the form calculation widget with field name "Total Cost"

    Adidng Values on Check boxes and Passing Value to Payment Total Field? Image 5 Screenshot 104

     

    6. If you have complex conditions for each value on options, what you can do is make a temporary text box field and hide it, it will act as a temporary storage for the value, we will then use that hidden field in our form calculation instead. 

    You may want to check this guides that we have to help you further: 

    How To Perform Form Calculation

    How To Pass Value on Payment Field 

     

    I hope this helps or at least gives you an idea on how to proceed. If you need help do let us know and we'll try our best.

    Thank you.

  • ballareinternational
    Replied on February 5, 2015 at 11:38 PM

    Thank you for the speedy response, really appreciate it!

    I have already entered all of my complex conditions (ie. special pricing bundles should one select more options), I would now like to tabulate the grand total.

    However, the problem now arise in that:

    When one selects Professional Open + Professional Closed-Asia, it still shows as $200.

    However, it is supposed to show as $350, which is a condition that i have input.

     

    Could you please assist me with this? 

    http://form.jotform.me/form/50334421525445

  • ballareinternational
    Replied on February 6, 2015 at 12:06 AM

    Just to clarify my question in case i was unclear:

    Basically, i found that the conditions are not reflecting accurately in my "Total Cost". 

    I have tried to apply similar conditions to another 'Total Cost" field and it does seem to work

     

    Would appreciate your help on this matter!

  • Charlie
    Replied on February 6, 2015 at 8:24 AM

    Hi,

    I've cloned again your form and added a Paypal method on it. When I choose Professional Open and Professional Closed - Asia it displays 350 and in my total field in Paypal it also shows 350. You can check the cloned form that I have here: http://form.jotformpro.com/form/50363680573962.

    May I know if you are embedding your form in a website? There might be a conflict with the codes in your website to the code of the form.

    We'll wait for your response.

    Kind regards.

  • ballareinternational
    Replied on February 6, 2015 at 8:52 AM

    Hi charlie,

     

    thanks for your help. i realised only selected conditions

    seem to work, not all. the professional open examples

    is currently working, however others such as the novice

    A + novice b isnt working.

     

    would appreciate your help.

     

    thanks!

  • Charlie
    Replied on February 6, 2015 at 10:27 AM

    Hi,

    I believe this is because the order of your conditions are quite incorrect. The order dictates the priority and what is already true in your rules. 

    Example is this condition block that you have:

    Adidng Values on Check boxes and Passing Value to Payment Total Field? Image 1 Screenshot 30

    I've added numbers on them so that you can understand what their priority order should be. Why is this important? Let's say the yellow highlight, the first one you have is this:

    If Standard Events is Equal To Pre-Amateur (W, T Q) is TRUE then add 100 to total. It means that EVEN THOUGH if other check box is also selected BECAUSE that is already a priority and is already TRUE the value inserted is already 100 and succeeding conditions will not be implemented.

    I've re-ordered that condition block and it should work correctly. Here's the updated form I have: http://form.jotformpro.com/form/50363680573962. See if that example condition work as expected.

    Adidng Values on Check boxes and Passing Value to Payment Total Field? Image 2 Screenshot 41

     

    I hope this helps. Do let us know if you have questions on this.

    Thank you.