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

    Spreadsheet widget: Calculated result not updating if the formula cell is set to read-only

    Asked by wefillforms on September 21, 2016 at 08:45 PM

    It seems if a formula cell is set to read-only, it does not update the calc when dependent values are changed??

     

    works fine if formula cell is Not read-only...  but then user can change formula.

     

    read-only spreadsheet widget then not read-only values
  • Profile Image
    JotForm Support

    Answered by liyam on September 21, 2016 at 09:55 PM

    Hello wefillforms.

    Can you try removing and adding again your spreadsheet widget and add again your settings? I can't seem to replicate the problem on a fresh form, but was able to recreate the problem on a form I cloned from yours. However, I managed to fix it by removing the widget and adding it again.

    We'll look forward to your updates on the matter.

    Thanks.

  • Profile Image

    Answered by wefillforms on September 21, 2016 at 10:46 PM

    Thanks for the quick response.  I have removed and re-added the widget.  same result.

    I also created a brand new form, same result.

    But, have noticed what causes it (but not the fix).

    If you click on the read-only cell, it "breaks" the formula.

    If you don't click on it, it updates just fine.

     

  • Profile Image
    JotForm Support

    Answered by Kiran on September 21, 2016 at 11:23 PM

    I am able to replicate the issue at my end with the cloned version of your form and a new form as well. Let me forward the issue to our backend team to take a look. Once we have any update in this regard, you'll be posted here.

    Thank you! 

  • Profile Image
    JotForm Support

    Answered by TitusNdoka on September 27, 2016 at 03:21 AM

    Hello - its been fixed - please check and let us know. 

  • Profile Image

    Answered by wefillforms on September 27, 2016 at 08:43 AM

    Works perfectly!

    Thanks for great support.