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

  • Profile Image
    christian_wagner
    Asked on June 18, 2015 at 07: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!

  • Profile Image
    raul
    Answered on June 18, 2015 at 08:32 PM

    This is possible by using the following CSS code.

    th { display: none; }

    This would produce the following result.

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

  • Profile Image
    christian_wagner
    Answered on June 19, 2015 at 01: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!

  • Profile Image
    david
    Answered on June 19, 2015 at 01: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.

  • Profile Image
    christian_wagner
    Answered on June 19, 2015 at 03:17 PM

    This is perfect. Thank you guys!

  • Profile Image
    david
    Answered on June 19, 2015 at 03: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.