Wrong total in the form?

  • Profile Image
    abcmississippi
    Asked on April 08, 2019 at 01:05 PM

    Hi, this registration for Mid South Elevator came in and they checked yes for the sponsorship. The total should be $550 and it is only $300 (for the 12 attendees at $25/each). What happened?


    https://www.jotform.com/submissions/90765937744169

  • Profile Image
    Nik_C
    Answered on April 08, 2019 at 02:30 PM

    Since your radio button is triggering calculation, your user most probably selected it and then added the names, but calculation will work only if the radio is clicked.

    So it might be better if you would assign calculation values to your radio:

    1554748195Screen Shot 2019-04-08 at 8.25

    And add it to calculation rather than using conditional logic for calculating it.

    Could that work for you?

    Please advise.

    Thank you!

  • Profile Image
    abcmississippi
    Answered on April 08, 2019 at 02:42 PM

    Yes, that would work. I added the calculation values and removed the logic. I added a new condition to copy the fields value to the Hidden Total but it is not working. I need it to be the total registered guests at 25/each PLUS this 250 if they choose it that shows in the total. Can you help me asap because now form is messed up :).

  • Profile Image
    Nik_C
    Answered on April 08, 2019 at 04:10 PM

    Ok, I would do it like this:

    1) For sign up total I would leave this condition:

    1554753783Screen Shot 2019-04-08 at 10.0

    2) So now we have Signup total where the calculation from the Attendee will show and we add the choice from the Selection:

    1554754049Screen Shot 2019-04-08 at 10.0

    3) The Total field can be deleted:

    1554754125Screen Shot 2019-04-08 at 10.0

    Please check my test form: https://form.jotform.com/90975824206968

    Let us know if that worked.

    Thank you!

  • Profile Image
    abcmississippi
    Answered on April 09, 2019 at 02:23 PM

    The reason that Total $ field is there is so that if they choose "send invoice" they'll see their total. Not everyone pays online. Thoughts?

  • Profile Image
    Nik_C
    Answered on April 09, 2019 at 03:02 PM

    You could insert one Text field that will be total and show it conditionally:

    1554836514Screen Shot 2019-04-09 at 9.00

    And insert calculation in it when total hidden is filled:

    1554836496Screen Shot 2019-04-09 at 8.58

    Please check my test form: https://form.jotform.com/90975824206968

    Thank you!