Conditional hidden fields being calculated in calculations

  • Profile Image
    amitinddr
    Asked on January 24, 2017 at 01:27 PM

    Hi Team JotForm

    I have form where I have a set of 5 fields. I have created copies of the 5 fields into 5 sets. Based on the number of sets selected by user from a different dropdown, the number of sets are shown and hidden. For example, if the dropdown value is "1", only one set of 5 fields will be visible. Similarly for values 2, 3, 4 and 5, the form shows total 2, 3, 4 and 5 sets respectively.

     

    A text box in the end shows a total of the 3rd field of each set. So for example, if the third fields of sets 1, 2, 3, 4 and 5 are 15, 20, 15, 30 and 40 respectively, the total will show 120. But if the user changes the number in first dropdown to 3 for example and the last 2 sets are hidden, the total text box does not update to show total of first 3. It continues to show total of all 5 fields. I have checked "Ignore Hidden Fields" but it doesn't help.

    PS: When I try to set "clear hidden field values" to "on being hidden from" preferences, it makes my form very slow. I do not want to go with this approach.

    Any help would be greatly appreciated.

  • Profile Image
    EltonCris
    Answered on January 24, 2017 at 03:24 PM

    The option you mentioned is designed for that purpose and I'm afraid there's no other way other than that. Selecting "Clear On Being Hidden" should fix it.

    I don't think this would affect the performance of the form. It should be working normally as it should.

    Try it again and let us know if there are any issue arises.