I would like to enter a table with information only for education

  • scorrado
    Asked on April 14, 2016 at 10:03 AM

    I would like to show a table with items and prices from several retailers and then have the respondents type in what they feel our price should be.

    For example

    1st item: Theraaband - 3 pack:

    Target price $$$,

    Target Brand Price $$$,

    Amazon Price $$$,

    Our Price $$$,

    Respondent's suggestion of our price - fill in ______

     

    I found the Spreadsheet widget, but I can't seem to save what I input in the cells.

  • Kiran Support Team Lead
    Replied on April 14, 2016 at 12:00 PM

    I've checked the widgets and it seems that the spreadsheet widget could be the right choice for your requirement. This widget allows to have the default values and you may also set the cells to read only so that the values cannot be changed while viewing the form. Let me work on a demo form with spreadsheet widget and get back to you.

    I've also checked with other widgets available and see that Data Grid widget may be another choice. But I'm not sure if it works for you.

    Alternatively, you may consider adding a table manually in the Text field.

    I would like to enter a table with information only for education Image 1 Screenshot 20

    Hope this information helps! If you need any further assistance, please let us know. We will be happy to help. 

  • Kiran Support Team Lead
    Replied on April 14, 2016 at 12:26 PM

    Please see the demo form below with the spreadsheet widget:

    https://form.jotform.com/61045074540952

    The default values for the spreadsheet are set as below:

    I would like to enter a table with information only for education Image 1 Screenshot 30

    I've set all these values as read-only so that they cannot be modified on the form. 

    I would like to enter a table with information only for education Image 2 Screenshot 41

    Also, I have added the following CSS code to the widget to hide the column headings and adjust the width of the columns.

    td.A > input {

    font-weight: bold !important;

    width: 160px !important;

    }

    #B1, #C1, #D1, #E1, #F1 {

    font-weight: bold !important;

    width: 90px;

    font-size: 12px;

    }

    th {

    display: none;

    }

    td.B, td.C, td.D, td.E, td.F {

    width: 300px !important;

    }

    Please feel free to clone the form to your account to see how the widget is configured.

    If you need any further assistance, please let us know. We will be happy to help.