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

    How Do I Make a Spreadsheet Cell (or row/column) Read-Only and Invisible to Users?

    Asked by dgspencer on March 30, 2015 at 10:42 AM

    Hi

    I used the Spreadsheet Widget to create a table that calculates and totals entries across a row.  Unfortunately, if a user clicks into the cells that have the totals, the formula is displayed and can be edited by the user.  Same situation applies to my headers and labels.  Is there a way to lock these cells down and also make the cell contents invisible to the user?

    http://form.jotform.us/form/50883728278166

     

    Thanks

    Daryl

    read-only and OR Make
  • Profile Image

    Answered by Carina on March 30, 2015 at 12:26 PM

    Unfortunately i believe it is not possible to achieve using the Spreadsheet widget, but a workaround might be using text-box fields/form calculation instead:

    You can test and clone the demo form:
    http://form.jotformpro.com/form/50884656429973? 

    Let us know if we can assist you further.   

  • Profile Image

    Answered by Carina on March 30, 2015 at 12:28 PM

    In addition if you want the totals field to be invisible you can right click the field and select hide:

     

  • Profile Image

    Answered by dgspencer on March 30, 2015 at 12:41 PM

    That really puts me between a rock and a hard place.  I can't use a matrix b/c it doesn't allow you to calculate and get a total.  I can't use the spreadsheet widget b/c the user can easily change the contents of the cell.  If I use text box fields, I can't put those into a table format.  I'm open to any suggestions...

  • Profile Image

    Answered by Carina on March 30, 2015 at 02:53 PM

    Visually on the form they can look like a table, but when exporting they will be treated as the other text fields.

    If you need calculation, I believe that at the moment text-box field option is the best available. I will forward a request to our developers so they can consider the future implementation of a feature that disables editing and make them invisible on the Spreadsheet widget.

    We'll contact you via this thread once we have more information.

    But please let us know more details on your needs so we can try finding a workaround.

  • Profile Image

    Answered by dgspencer on March 30, 2015 at 03:11 PM

    that would be a very useful feature to have in the spreadsheet widget.  but tell me this:  would I use CSS in making the text boxes resemble a table?  I'm fairly new to creating forms with JotForm; I'm a recently rescued Adobe refugee.

  • Profile Image

    Answered by Carina on March 30, 2015 at 03:42 PM

    So welcome aboard! =)

    Please take a look at the test form:

    http://form.jotformpro.com/form/50884656429973? 

    You can clone it if you want:

    http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL  

    If you need further assistance please let us know and we'll be glad to assist you.

  • Profile Image

    Answered by dgspencer on March 31, 2015 at 10:50 AM

    I...I simply don't know what to say.  This level of customer service is unheard of and hasn't been seen in decades.  Are you people real because the service you give is simply too good to be true.  I'm absolutely in awe by the assistance, time, effort and dedication you give to JotForm users.  EVERY SINGLE problem I've encountered has either been resolved or easy, good-working alternatives given to me.  Saying "Thank you" hardly seems sufficient for all the help I've gotten since becoming (as I like to put it) an exiled refugee from A***e.  Boy, you people could give THEM some lessons! 

    Thank you so much, Carina....but I'm still wondering...who are you guys?  Nothing could be THIS good!

    :-)

  • Profile Image

    Answered by Carina on March 31, 2015 at 12:04 PM

    Thank you so much for your amazing feedback. I've shared it with the team. I'm very happy that you are having a nice transition and that you are happy with Jotform and with the support provided.

    Besides having a great product, we strive at providing excellent customer support, so thank you for letting us know that this was the case for you. It really makes our day to be able to read such a positive feedback.

    If you need further assistance please let us know as we're here to help.

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on March 31, 2015 at 12:59 PM

    @dgspencer

    Hearing your cheerful feedback is VERY important to us. We are a very passionate team who really enjoy helping our users and customers to the best of our abilities. Our support team is spread around the 5 continents as we offer a 24/7 support service.

    This is what makes JotForm even greater.

    We celebrate as a team when one of our representatives makes someone happy, like Carina did.

    Thank you for your wonderful feedback.

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on March 31, 2015 at 01:00 PM

    Besides my thank you note, here is an enhanced version of Carina's workaround. You can clone it and use it for your requirements

    http://form.jotformpro.com/form/50884656429973

     

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on March 31, 2015 at 01:01 PM

    Actually, I was very excited reading your message that I posted the incorrect one above,  this is the correct one, feel free to clone it, using the guide Carina showed you above.

    http://form.jotformpro.com/form/50894546707971

    Cheers!

    :D

  • Profile Image

    Answered by mulvinc on May 13, 2015 at 11:40 AM

    I just tried some different options (as I also need a budget form), and I discovered that you can use the Calculation widget with a matrix.

    Set up your matrix, then select matrix as the field to calculate in the Calculation widget. You can select the rows/columns on that matrix in the widget.

    See: http://form.jotformpro.com/form/51324940805957

     

    I have to play around with it to get it to line up...but it does work. I'd prefer to just use the spreadsheet widget with the option to lock fields, but in the meantime, this will do.

  • Profile Image
    JotForm Support

    Answered by ashwin_d on May 13, 2015 at 12:16 PM

    Hello mulvinc,

    I am glad to know that "Matrix" field fits into your requirement. Do try it out and get back to us if you need further help.

    Thank you!

  • Profile Image
    JotForm Support

    Answered by TitusN on December 03, 2015 at 06:55 AM

    Hello, 

    We've updated the spreadsheet widget to make cells "read only", for example, this form - https://form.jotform.com/53363229253959? - the last column is read-only. 

    Here's the configuration:

    Please give it a try - and share your feedback. 

    Thanks!

  • Profile Image

    Answered by forusretail on April 28, 2016 at 04:51 PM

    About the new spredsheet widget, I would like to know if I can hide the first row and column (A,B,C... and 1,2,3). Is it possible?

     

    Thanks

  • Profile Image
    JotForm Support

    Answered by Kevin_G on April 28, 2016 at 05:12 PM

    @forusretail,

    I have moved your question to this thread: https://www.jotform.com/answers/828914

    We will assist you with that as soon as possible.