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

  • Profile Image
    jabedoya60
    Asked on July 17, 2017 at 08:35 PM
    can we get rid of the labels on the top and the left side?
  • Profile Image
    Kevin_G
    Answered on July 17, 2017 at 09: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. 

  • Profile Image
    jabedoya60
    Answered on July 19, 2017 at 07:49 PM

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

  • Profile Image
    Kevin_G
    Answered on July 19, 2017 at 09: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? 

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

     

  • Profile Image
    jabedoya60
    Answered 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.

  • Profile Image
    jabedoya60
    Answered 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.

  • Profile Image
    Nik_C
    Answered on July 22, 2017 at 04: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!

  • Profile Image
    jabedoya60
    Answered 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,

  • Profile Image
    Nik_C
    Answered on July 23, 2017 at 02: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:

    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?

     

  • Profile Image
    jabedoya60
    Answered on July 25, 2017 at 07: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.

  • Profile Image
    ashwin_d
    Answered 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!

  • Profile Image
    jabedoya60
    Answered on July 26, 2017 at 07: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.
  • Profile Image
    Kevin_G
    Answered on July 26, 2017 at 08:36 PM

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