Wrong total in the form?

  • abcmississippi
    Asked on April 8, 2019 at 1: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

  • Nik_C
    Replied on April 8, 2019 at 2: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 Screenshot 10

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

    Could that work for you?

    Please advise.

    Thank you!

  • abcmississippi
    Replied on April 8, 2019 at 2: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 :).

  • Nik_C
    Replied on April 8, 2019 at 4: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 Screenshot 10

    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 Screenshot 21

    3) The Total field can be deleted:

    1554754125Screen Shot 2019 04 08 at 10 Screenshot 32

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

    Let us know if that worked.

    Thank you!

  • abcmississippi
    Replied on April 9, 2019 at 2: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?

  • Nik_C
    Replied on April 9, 2019 at 3:02 PM

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

    1554836514Screen Shot 2019 04 09 at 9 Screenshot 10

    And insert calculation in it when total hidden is filled:

    1554836496Screen Shot 2019 04 09 at 8 Screenshot 21

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

    Thank you!