Spreadsheet Widget: How to get rid of labels in the top and left side?

  • jabedoya60
    Asked on July 17, 2017 at 8:35 PM
    can we get rid of the labels on the top and the left side?
  • Kevin Support Team Lead
    Replied on July 17, 2017 at 9:19 PM

    Please, inject the following CSS code to the widget in order to get rid of the left and top labels: 

    tr th {

        display: none !important;

    }

    This guide will help  you injecting the code to the widget: https://www.jotform.com/help/428-How-to-Inject-CSS-Codes-to-Widgets 

    I hope this helps. 

  • jabedoya60
    Replied on July 19, 2017 at 7:49 PM

    Hi, sorry but I placed the css code and it did not work. Is there anything that can be done?

  • Kevin Support Team Lead
    Replied on July 19, 2017 at 9:30 PM

    I have checked the widget on your form and did not find any injected CSS code, could you please add it and let us know if it does not work? 

    Spreadsheet Widget: How to get rid of labels in the top and left side? Image 1 Screenshot 20

    We will be glad to take a look on your form. 

     

  • jabedoya60
    Replied on July 22, 2017 at 12:02 PM

    Hi, thank you I was placing the css in the wrong place, the form is coming together but I still have some problems, I need the text to be centered, smaller in size because there are some fields that a lot of text and all the text in those fields do not show up and last where the prices are, can a checkbox be place in that field so a total can be added at the bottom? Please take a look at my original form below, thank you again for all your help.

    Spreadsheet Widget: How to get rid of labels in the top and left side? Image 1 Screenshot 20

  • jabedoya60
    Replied on July 22, 2017 at 12:03 PM

    I don't need the 6th column, everything can be added on the bottom of the 5th column.

    Thank you.

  • Nik_C
    Replied on July 22, 2017 at 4:15 PM

    I understand you were able to fix this issue?

    Since I saw that you added the total field at the bottom of the 5th column.

    If I misunderstood, please let us know.

    Thank you!

  • jabedoya60
    Replied on July 23, 2017 at 11:48 AM

    Hi, yes i fixed the issues of the labels but did you read my note above, there are still several issues, I need the form to look like the graphic above and be able to add the last column when the user selects that row?

    Thank you,

  • Nik_C
    Replied on July 23, 2017 at 2:32 PM

    I'm sorry when I read that reply I understood it is fixed as well.

    Ok here is the CSS that will make all cells text centered and I decreased the font:

    .cell-input {
        text-align: center;
        font-size: 12px!important;
    }

    It should look like this:

    Spreadsheet Widget: How to get rid of labels in the top and left side? Image 1 Screenshot 20

    You can make the font size in the code above, just put the smaller number.

    Now, I didn't understand where the check box should be that will show the additional column and where that column should show?

    On the right hand-side, I assume?

     

  • jabedoya60
    Replied on July 25, 2017 at 7:37 PM

    Hi, thank you, yes, all is left is too be able for the user to select and add the price of the classes.

    Yes, on the right side is fine but here is another idea since we are so tight for space, I can take the first Column, # of Lessons and place that info inside and combined with the info in the third column with the title time, then we can place the check boxes in the first column?

    Whatever works and fits we are good with it, I wish some of the cells could support 2 lines since some of them have a lot of text inside of them.

    Thank you again.

  • Ashwin JotForm Support
    Replied on July 26, 2017 at 12:41 AM

    Hello jabedoya60,

    Do you mean to say that you want to add a checkbox field in "Spreadsheet" so that users can select the desired rows?

    Unfortunately it is not possible to add checkbox field in spreadsheet widget. Even if we manually add checkbox field outside the widget and place it next to each row, it won't be possible to calculate the total based on the selection of checkbox field.

    Please confirm if this is what your requirement it and we will see if come up with any workaround to achieve your requirement.

    We will wait for your response.

    Thank you!

  • jabedoya60
    Replied on July 26, 2017 at 7:05 PM

    Hi, any suggestions will be much appreciated, just want the parents to select the classes they want and a total added at the bottom right field, that is all. thank you.
  • Kevin Support Team Lead
    Replied on July 26, 2017 at 8:36 PM

    Your last question will be addressed here: https://www.jotform.com/answers/1209480