How to change content of first column of Spreadsheet widget

  • BJ2
    Asked on April 5, 2016 at 7:28 AM
    On Spreadsheet Widget, how can I change contents on the first column of the table (they're only numbers)?
    I could only change the Column Header through reading other threads...please help...
  • jonathan
    Replied on April 5, 2016 at 8:07 AM

    I was able to modify it using CSS code like this.

     

    th#row_1,th#row_2 {

        visibility: hidden;

    }

    th#row_1::after {

        visibility: visible;

       content: "TEST";

     color:black;

    }

    th#row_2::after {

        visibility: visible;

       content: "TEST2";

     color:black;

    }

     

    (the code above is for the 2 rows only... it can be expanded by duplicating and use the sequence number)

    How to change content of first column of Spreadsheet widget Image 1 Screenshot 30

     

    here is the test form https://form.jotform.com/60953000895961

    How to change content of first column of Spreadsheet widget Image 2 Screenshot 41

     

    Hope this help. Let us know if this did not work for you.

     

  • BJ2
    Replied on April 5, 2016 at 10:08 AM

    Hi Sir Jonathan!
    WOW! Fantastic! 
    Thank you vvveeeerrrryyy much for your hard work Sir!
    I will then use the codes you provided!

    GOD bless JotForm Support Team more and more!

  • Ashwin JotForm Support
    Replied on April 5, 2016 at 11:22 AM

    Hello BJ2,

    On behalf of my colleague, you are welcome. 

    DO try out the custom css code and get back to us if you have any questions.

    Thank you!

  • BJ2
    Replied on April 5, 2016 at 12:26 PM

    Hi again Sir Jonathan and Sir Ashwin_d!

    I tried it already and only found that black border lines are missing....
    Is it possible to keep the black border lines?

  • Ashwin JotForm Support
    Replied on April 5, 2016 at 12:53 PM

    Hello BJ2,

    I am trying to work on your custom css requirement but it is taking time. I will get back to you on this soon.

    Thank you!