Is it possible to edit the header rows or columns in the spreadsheet widget?

  • Profile Image
    ORMTANewmarket
    Asked on August 13, 2016 at 06:08 PM

    Is it possible to edit the header rows or columns in the spreadsheet widget? For example, rather than "A, B, C" along the top to rename them as "Name, Age, etc."



    This is a re-post of a comment on Customize Your Form Using Custom CSS Codes

  • Profile Image
    Welvin
    Answered on August 13, 2016 at 06:51 PM

    It's not possible, but you can do the following to replace the texts.

    1. Inject the following custom CSS codes to hide the text in Column A:

    th#col_A {

        color: transparent;

    }

    For other columns, just replace A with B and C and D and so on. You can only just separate the columns with comma, for example:

    th#col_A,  th#col_B {

        color: transparent;

    }

    Just make sure not to add a comma after the last item.

     

    2. Inject the following custom CSS codes to add a text in Column A:

    th#col_A:after {

        content: "Name";

        color: #fff;

        margin-left: -10px;

    }

    For other columns, just replace A with B and C and son on. Note, this time, you'll need to separate the codes for each column since there is the "content" style. You need to replace the Name in the content with your own text, enclose with an inverted comma or double quotes. 

    Please note that this workaround is only for the form view, the backend will still appear as A, B, C and so on.

    Here's my test form: https://form.jotform.com/62246602499966

    Let us know if you have questions.

  • Profile Image
    ORMTANewmarket
    Answered on August 13, 2016 at 08:25 PM

    Got it now. Thank you!

  • Profile Image
    liyam
    Answered on August 13, 2016 at 08:40 PM

    On behalf of Welvin, You are welcome.

    Feel free to let us know if you have other questions by posting a new topic. 

    Thanks.

  • Profile Image
    MadGarcia
    Answered on October 17, 2016 at 03:22 PM

    Is it possible to change the rows just like we did with the columns?

     

  • Profile Image
    John_Benson
    Answered on October 17, 2016 at 05:38 PM

    In order for us to assist you better, I have moved your question to a new thread. Here's the link:

    https://www.jotform.com/answers/963414

    Please wait for our reply shortly. Thank you.