Calculation field not updating properly

  • SEFAA2017
    Asked on December 24, 2017 at 1:06 PM

    We have member and non-member pricing and you select which you are eligible for with a radio button field.

    If you click Member, you get a set of five read-only fields that summarize the four rental items you can select (#full-day rentals, total # of extra participants for full-day rentals, and ditto for half-day rentals) and then the fifth is a calculation widget that adds the values of the first four fields.

    If you click Non-member, you get a different set of five read-only fields. The only change from the member set above is higher pricing.

    Everything works fine if you just select member or non-member and then work through the rest of the form. If, however, you toggle between member and non-member (say you want to see how much you're saving by being a member), then the calculation widgets stop working properly. They seem to pick up less of the four relevant read-only fields with each toggle.

    In the attached screenshot, I had selected one full-day rental with 5 extra participants and 2 half-day rentals with a total of 2 extra participants. The screenshot is after I toggled from member to non-member pricing. You can see that the four rental item pricing fields are correct but the total is most obviously not correct.

    What's up and how do I fix it please?

    Jotform Thread 1330759 Screenshot
  • David JotForm Support Manager
    Replied on December 24, 2017 at 1:59 PM

    It seems like the values from the previous selection don't clear, and that is the reason why the issue happens when you toggle, please try enabling the "Clear on being hidden" option:

    1514141907clearonbeinghidden Screenshot 10

  • SEFAA2017
    Replied on December 24, 2017 at 2:07 PM

    I changed that setting as you suggested, but the total number is still not right if I toggle from member to non-member or visa versa.

    Would it make any difference if I changed the total fields from calculation widgets to conditional calculations?

    Any other ideas?

  • TREVON
    Replied on December 24, 2017 at 2:57 PM

    I have tested your form and I am getting different values for Members and Non-members.

    Would you kindly confirm which calculation is not working based on the above as it seems the calculation are ok.

    1514145369calculations Screenshot 10

  • SEFAA2017
    Replied on December 24, 2017 at 3:15 PM

    It's the total rental cost that isn't calculating correctly. It should be filled in for either member or non-member and you should be able to toggle back and forth between member and non-member and have the total update accordingly. (members pay more to rent than non-members do)

  • David JotForm Support Manager
    Replied on December 24, 2017 at 6:23 PM

    I apologize for the long delay, but it took me awhile to figure it out after doing many tests. In order to fix the problem, it is necessary to delete the calculation from the "Total Rental Cost" widgets, and perform them through conditions:

    1514157592one Screenshot 10

    1514157606two Screenshot 21

    Also, please set the "Clear hidden field values" to "Clear on Submit":

    1514157712clearonsubmit Screenshot 32

    Please test my clone version here: https://form.jotform.com/73577369826979 

    Let us know if you need more help.

  • SEFAA2017
    Replied on December 24, 2017 at 7:18 PM

    I haven't made the changes yet, but your cloned form works! Thank you!!!


    PS For the future, do you have guidance on when to use the calculation widget vs conditional calculations? I guess I'm really asking why one works here and the other doesn't?


    PPS Merry Christmas Eve!

  • John_Benson
    Replied on December 24, 2017 at 8:37 PM

    For the Form Calculation widget, you can check the guide on this link:  https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    For the Conditional Calculations, please check this guide: https://www.jotform.com/help/268-How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic

    I hope these guides will help you.