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

    Widgets: Form Calculation's IGNORE HIDDEN FIELDS option leads to 0 results

    Asked by assuntoseducacionais on May 26, 2017 at 05:34 AM
    Testing the form today, I saw the calculation fields are showing "0" as a fixed result now, instead of the previous blank results. However, they still aren't being able to perform the calculations.
  • Profile Image
    JotForm Support

    Answered by Jim_R on May 26, 2017 at 06:18 AM

    I think the issue lies with the the IGNORE HIDDEN FIELDS option.

    When enabled, it causes the widget's result to be always 0, if the value comes from a HIDDEN FIELD with a DEFAULT VALUE.

    Here's a simple form (71451946345965) where I have 3 hidden Textboxes with default values that are conditionally shown (a somehow simpler version of your current form).

    Then, there are 3 corresponding Form Calculation Widgets where the values of these Textboxes are being passed respectively.

    Textbox 1 value to Calculation 1

    Textbox 2 value to Calculation 2

    Textbox 3 value to Calculation 3

    The IGNORE HIDDEN FIELDS option is NOT enabled on the first 2 widgets and they are working as intended.

    The IGNORE HIDDEN FIELDS option IS enabled for the 3rd widget and that last one isn't working.

    I've escalated this to our Devs and although I won't be able to give you any timeframe, rest assured, we'll keep you apprised on this same thread when there's an update.

  • Profile Image

    Answered by assuntoseducacionais on May 30, 2017 at 02:09 PM

    Good afternoon.

     

    I'd like to know if there are any news about the adjustment of "IGNORE HIDDEN FIELDS" functionality in form calculation widget.

     

    Regards.

  • Profile Image
    JotForm Support

    Answered by Welvin on May 30, 2017 at 03:14 PM

    The ticket is still open. Our widget team will give you the updates here once available. 

  • Profile Image
    JotForm Support

    Answered by widgets on May 31, 2017 at 06:58 AM

    Hi @assuntoseducacionais, I want some clarifications about this ticket. Your main problem is that your form field is getting "0" instead of a blank value. While the "Ignore Hidden Fields" option is set. Is this correct? We need this information so we can further check the problem.

    Regards,
    Widget Team

  • Profile Image

    Answered by assuntoseducacionais on May 31, 2017 at 08:39 PM

    The form works as follows:

    - 1st, by means of the configurable list widget field on the top of the form, the user selects a course.

    - 2nd, informations of this course, which are inline with the respective course name, are showed.

    - 3rd, as fields that were hidden up to then are selected by user and become visible, calculation widgets sum up the corresponding values recorded on those fields. The summation runs inside each column of the matrix arrangement. The number of fields that are included in the summation depends upon the course selection by the user. All the other not selected fields remain hidden and are to be ignored in the sum.

     

    The problem that has led me to request your support is the following one:

    As ilustrated here, the option "IGNORE HIDDEN FIELDS" is causing those fields that were initially set as hidden to continue not having any effect on calculations after they are called to become visible by the action of "SHOW/HIDE FIELDS"conditions.

    The expected behaviour should be that those initially hidden fields ceased to be ignored and started to participate in calculations as soon as they were selected to become visible.

    In short, a changing in the field's visibility should influence on the result of a calculation in which this field is involved, but this is not the observed behavior.

  • Profile Image
    JotForm Support

    Answered by widgets on June 01, 2017 at 08:30 AM

    Hi, we fixed the problem, it should be working now. Can you please test it and let us know.

    Regards,
    Widget Team

  • Profile Image

    Answered by assuntoseducacionais on June 01, 2017 at 01:30 PM

    Yes, it's working perfectly. I'd like to thank you all! All of you in support and widget team have been doing an outstanding job! Congratulations!