How can I add text to the cells of the spreadsheet widget?

  • Profile Image
    Asked on May 31, 2015 at 10:39 AM
    2. I need to have fixed text as part of the form in the fields under the columns with headings of: Kayak Event, # Veterans, # Families, # Volunteers, and # volunteer Hours.  When I enter the text for those columns and save the form the text is not there when I call the form up.  How do I save text in the fields as part of the form?
  • Profile Image
    Answered on May 31, 2015 at 08:40 PM


    I checked one of your form and it seems you were able to achieve this. 

    If there's anything else you need help with, let us know. 

  • Profile Image
    Answered on May 31, 2015 at 10:28 PM

    Yes, the coding changes fixed the header display problem, but my other question and problem has not been addressed!  Our use of JotForm depends on being able to solve this problem.

    The first link is the form I'm working on and the second link is from the "Embedded Form" button.

    The problem is that I need to have text in multiple cells in the spreadsheet and that text be a permanent part of the form that is distributed to be completed by end users.  For example:

    Cell A1:  1st Outing Date

    Cell A2:  # Outing Days

    Cell C2:  #Veterans

    Cell C3:  # Male

    Cell C4:  # Female

    Cell C5:  # 1st Time Male

    Cell C6   # 1st Time Female


    I've gone through all the postings I can find and cannot find an answer.  surely there is a way to freeze the text within cells.  How do I do that?


  • Profile Image
    Answered on June 01, 2015 at 08:30 AM

    Hello HOWNewForms,

    If I understand your requirement correctly, you want to make few of your spreadsheet widget's cell NOT editable. Is that correct?

    Unfortunately it is currently not possible to make spreadsheet cell read only. Can you please explain your requirement a bit more in detail. Do you want only specific cell to be read only but other cells within that column needs to be editable?

    I am not sure if that is possible within the widget but we will take a look. We will wait for your confirmation.

    Thank you!

  • Profile Image
    Answered on June 01, 2015 at 01:00 PM

    I need to be able to create the form with text in various cells in columns A, C, E, G, and I.  That text is to be not editable and is a permanent part of the form.  The user that is competing and submitting the form would see the text and only enter data in the appropriate cells in columns B, D, F, H, and J. 

    For example, the user completing the form would see in cell A1 "1st Outing Date" and then enter the date in cell B1.  Cell C1 would have "# Veterans" and the user would enter a numeric value in D1.  Approximately 85 cells in columns A, C, E, G, and I would have permanent text and only cells in B, D, F, H, and J would the user enter numeric values. 

  • Profile Image
    Answered on June 01, 2015 at 02:46 PM

    If I understood your question correctly you want to add prepopulated fields in some rows in one column and you want to disable those fields, so your user can not enter new values in them. 

    You can achieve that by adding this CSS code inside of your Spreadsheet widget.


    Here is a demo form I made, where I entered default values inside of column A1, A2 and A3, but I have disabled column A so users can not change default values. 

    Whit this CSS code you can disable any column you want.

    Hope this will help. Let us know if you need further assistance.

  • Profile Image
    Answered on June 01, 2015 at 03:56 PM

    Thank you and this does seem to solve the problem.  I've only entered part of the data, but feel comfortable that it is resolved.

  • Profile Image
    Answered on June 01, 2015 at 05:11 PM

    I just quick checked your form and I saw that you did not set additional code correctly. Your fields are still clickable.

    You should set it like this.

    Feel free to contact if you have any other questions.