is there a way to enter a name that that sends a value to total due

  • pitterpatties
    Asked on January 14, 2016 at 11:03 PM

    Hello,

    I have been trying to calculate this form with both the form calculator and conditions. I cannot get it to work. Can you please help? I need the form to be able to have the person type in their name and cost show up in the total due, same applies to Additional Girls & Additional Pictures. Plus the

    Register button goes to a thank you page and not Paypal.
    I took all the conditions & calculations off and added dropdown boxes with values added. Still no luck.

     

    Thank you for any help you can provide.  I have read all the guides until my head was going to explode, still can't figure it out. 

     

    Please feel free to clone my form.

     

     

  • Chriistian Jotform Support
    Replied on January 15, 2016 at 3:25 AM

    Hi,

     

    I see that the you have posted two questions in the same thread. I have moved your concern about paypal to another thread so we can assist you better. Here is the link to that thread: http://www.jotform.com/answers/745737 

    As for your initial concern, allow me to investigate this issue further. I will inform you on this thread once there is a possible workaround. 

    Regards.

  • Chriistian Jotform Support
    Replied on January 15, 2016 at 4:01 AM

    Hi,

     

     

    You have to remove the conditions from the calculation widget as it overrides the calculations. Instead add hidden fields that will serve as a placeholder where you will put the conditions when a user enters a name in the given fields.

    For example, when a user inputs the guy's and the girl's name, the hidden field called total guys and girls will have a value of 15 based on the condition given.

    is there a way to enter a name that that sends a value to total due Image 1 Screenshot 70

    Then in the calculation widget, you have to add the total of all the hidden fields plus the total pictures.

    is there a way to enter a name that that sends a value to total due Image 2 Screenshot 81

     

    Here are the conditions that I added in the cloned form.

    is there a way to enter a name that that sends a value to total due Image 3 Screenshot 92

    And these are the hidden fields that serves as a placeholder for the values to be added by the calculation field.

    is there a way to enter a name that that sends a value to total due Image 4 Screenshot 103is there a way to enter a name that that sends a value to total due Image 5 Screenshot 114

    Here's a screenshot of the Total Due where all the guys and girls fields are filled and the number of additional pictures is 1.

    is there a way to enter a name that that sends a value to total due Image 6 Screenshot 125

    You can follow this link if you want to see the cloned form where I added the conditions in action: https://form.jotform.com/60141832664957

    You can also clone it in your account if you want to see the conditions set. Here's how: How to Clone an Existing Form from a URL

     

     

    Do inform us if you need further assistance,
    Regards.

  • pitterpatties
    Replied on January 15, 2016 at 8:39 AM

    OMG, Chriistian this is great! I can't tell you how many hours I worked on this and how many different conditions and calculations I tried with no success. I have a couple questions.  How do I set a condition for the Processing Fee to calculate 2.20% + 0.30 cents based on the total due? And is there a way to set the Additional Pictures to 0 since not everyone orders extra pictures.  Thank thank you very much for your help. :-) And can a dollar sign be added to the total?

  • pitterpatties
    Replied on January 15, 2016 at 8:40 AM

    http://www.jotform.com//?formID=60143365070951

  • David JotForm Support Manager
    Replied on January 15, 2016 at 11:57 AM

    You can accomplish it by going to Conditions, selecting UPDATE/ CALCULATE FIELD, and create a calculation like this:

    is there a way to enter a name that that sends a value to total due Image 1 Screenshot 70

    Result: 

    is there a way to enter a name that that sends a value to total due Image 2 Screenshot 81

    If you want the Processing FEE and Total Due to be reflected in the "Registration Total", add a new Form Calculation widget, and assign it to the Integrated Payment field:

    is there a way to enter a name that that sends a value to total due Image 3 Screenshot 92

    Result:

    is there a way to enter a name that that sends a value to total due Image 4 Screenshot 103

    You can always hide fields, by selecting the field, clicking on the gear icon and 

    is there a way to enter a name that that sends a value to total due Image 5 Screenshot 114

    Here is my cloned version: https://form.jotform.com/60144186661959

    On regards of setting the "Additional picture" field to 0,  you can do it by clicking on the gear icon>>Edit Properties>>Selected.

    is there a way to enter a name that that sends a value to total due Image 6 Screenshot 125

    Let us know if you need more help, we will be glad to assist you.