Further clarification on instructions regarding calculations

  • Profile Image
    SunbridgeInstitute
    Asked on January 15, 2016 at 11:01 AM

    Hi support team. I was given some instructions from Ben which I am quoting below (in yellow)--the original thread was here: http://www.jotform.com/answers/744965-Calculation-conditions-not-working

    I have some questions about these instructions.

    So what I did was to clone your form so that I can make changes on it without affecting your form. Then I made a screencap of what I meant.

    You will see that all I did was to delete the form calculation widget of retrieving the value of the checkbox field.

    As per my comments above, this will work, but is likely to cause further issues later on, so to make it work for tomorrow, you can apply the same change as I did and say that you would like to make further optimization for future use.

    Then replace the form calculation widget with a plain textbox field that gets updated with the conditions instead.

    Or a faster option (and do feel free to let me know if I need to add more details :) ) to simply change the value of form calculation to deduct the value using another field that gets updated by conditions instead.

    OK, to avoid any confusion, this is the screencap of the first thing - form calculation and removing its value grabbing setup and seeing how it automatically starts working in the preview:

    Want to check it out for yourself? Easy, just check this form:https://form.jotform.com/60135754721957

    Want the form without doing the same steps - easy with the clone option: How to Clone an Existing Form from a URL

    The steps to replace the same with textbox would be as follows:

    1. add textbox to your form

    2. set conditions that are updating the form calculation - Discounts received for Waldorf Weekend field through conditions to update the textbox we added in first step

    3. the values need to be changed so that they are prepared for deducting from the subtotal.

    4. edit form calculation (Discounts received for Waldorf Weekend field) to deduct a value of subtotal with the value of textbox we created above.

     

    So I've gotten to the point where I am adding in a textbox field to my form (as per #1 above), and I take it that the idea here is to basically recreate the conditions that I had on the prior "calculation widget" field over to my new textbox field. Is that what I need to do? I'm not really understanding steps 2-4 that are described above. If someone can clarify, I'd appreciate it.

    I would also like to know more details about this sentence below:

    Or a faster option (and do feel free to let me know if I need to add more details :) ) to simply change the value of form calculation to deduct the value using another field that gets updated by conditions instead.

    Thank you so much!

  • Profile Image
    Mike
    Answered on January 15, 2016 at 01:54 PM

    As long as the calculation fields are working fine on your form, you do not need to replace them. You can populate a Calculation field with condition in the same way as you do with a Text Box field.

    I would also like to know more details about this sentence below:

    Or a faster option (and do feel free to let me know if I need to add more details :) ) to simply change the value of form calculation to deduct the value using another field that gets updated by conditions instead.

    I am not quite sure if I followed Ben's suggestion since there should be many ways to accomplish calculations on complex forms, but here is an example of the calculation based on conditions and calculation values.

    http://www.jotform.com/answers/745969

    If you need any further assistance, please let us know.

  • Profile Image
    SunbridgeInstitute
    Answered on January 15, 2016 at 02:08 PM

    Thank you. I would really like to get Ben's explanation of his steps 2-4 or at least see if I have restated the solution accurately.

    Also, I'm really interested in hearing Ben's details about that highlighted sentence, since it seems key in my understanding of the overall approach I'm taking on this long and complex form.

    Thank you very much!