How can I remove the first column and row on the spreadsheet widget?

  • christian_wagner
    Asked on June 18, 2015 at 7:30 PM

    Hi all,

    I'm looking to edit my spreadsheet widget so I can eliminate the "A, B, C" row and "1, 2, 3" column. I saw some CSS but I'd like to totally delete these if possible. Any suggestions?

    Thanks!

  • raul
    Replied on June 18, 2015 at 8:32 PM

    This is possible by using the following CSS code.

    th { display: none; }

    This would produce the following result.

    How can I remove the first column and row on the spreadsheet widget? Image 1 Screenshot 20

    Let us know if this is what you're trying to accomplish.

  • christian_wagner
    Replied on June 19, 2015 at 1:19 PM

    Hi Raul - this solves my problem for the front end. Is there a way to mirror this in the submission email for the person receiving the form? Thanks!

  • David JotForm Support
    Replied on June 19, 2015 at 1:42 PM

    Unfortunately, since the headers are necessary for the spreadsheet functionality, it is not possible to remove them the submission data.  They are the ID's used for equation functionality and things of that nature so they cannot be fully removed from the widget.

    You could use something like the configurable list widget:

    http://widgets.jotform.com/widget/configurable_list

    This would function much more closely to your current setup without having to remove and headers.  It would also allow you users to customize the number of entries for the field.

    If you have any further questions, let us know and we will be happy to help.

  • christian_wagner
    Replied on June 19, 2015 at 3:17 PM

    This is perfect. Thank you guys!

  • David JotForm Support
    Replied on June 19, 2015 at 3:28 PM

    You are very welcome!  Just let us know if there is anything else we can assist you with and we will be happy to do so.