What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Further clarification on instructions regarding calculations

    Asked by SunbridgeInstitute 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!

    Page URL:
    http://www.jotform.com//?formID=60143546937964

    calculation form form calculations
  • Profile Image
    JotForm Support

    Answered by Mike 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

    Answered by SunbridgeInstitute 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!