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

  • ORMTANewmarket
    Asked on August 13, 2016 at 6: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."

  • Welvin Support Team Lead
    Replied on August 13, 2016 at 6: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.

  • ORMTANewmarket
    Replied on August 13, 2016 at 8:25 PM

    Got it now. Thank you!

  • liyam
    Replied on August 13, 2016 at 8: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.

  • MadGarcia
    Replied on October 17, 2016 at 3:22 PM

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

     

  • John_Benson
    Replied on October 17, 2016 at 5: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.