Spreadsheet Widget: Create dropdown inside the widget

  • ronak2303
    Asked on May 28, 2017 at 8:47 PM

    hello,

     is there any way i an create drop down in Spreadsheet Widget.

    for ex.

    attached screen shot, i want make drop down selection for Column B and in column C to input Amount.

    is there any way i an achieve this.

    i tried configuration widget but it does not give me total. even if i want to limit it to 10 new entry.

    Jotform Thread 1156728 Screenshot
  • Chriistian Jotform Support
    Replied on May 28, 2017 at 9:51 PM

    To perform the calculation in the Spreadsheet Widget, you need to add default values or formulas to the cells. For example, please see the image below:

    Spreadsheet Widget: Create dropdown inside the widget Image 1 Screenshot 30

     

    Regarding the drop-down selection, did you mean you want to have a dropdown in the Spreadsheet Widget? If yes, please allow me to inform you that it is not possible to add a dropdown selection on the widget. 

    Alternatively, I would suggest you add an Input Table on your form instead, where you can choose a dropdown selection an input type.

    Spreadsheet Widget: Create dropdown inside the widget Image 2 Screenshot 41

     

    Then, you can perform calculations on input table by following the instruction in this guide: How to Perform Form Calculation in the Matrix Field?

    Let us know if you need further assistance.
    Regards.

     

  • ronak2303
    Replied on May 29, 2017 at 12:24 AM

    Hello Sir, thx for support.

    but for input table i do not need multiple choice for each column.

    for ex. in first 3 column no need for multiple choice, last column "Not satisfied" i want to have drop down.

     

    is it possible.

     

     

     

  • Chriistian Jotform Support
    Replied on May 29, 2017 at 1:25 AM

    You can add two Input tables on your form and shrink them so that the last column will have a dropdown.

    Spreadsheet Widget: Create dropdown inside the widget Image 1 Screenshot 30

    So it should look like this:

    Spreadsheet Widget: Create dropdown inside the widget Image 2 Screenshot 41

    However, if you mean something else, please clarify your requirements a bit more and let us know further you need further assistance.
    Regards.

  • ronak2303
    Replied on May 29, 2017 at 1:47 AM

    hi, 

    i am trying to get something like "Configurable List" but with amount total.

  • Chriistian Jotform Support
    Replied on May 29, 2017 at 1:57 AM

    It is not possible to perform calculations using the Configurable list widget. What I would suggest, is to create separate fields instead so that to be able to perform calculations using the Form Calculation Widget.

    Spreadsheet Widget: Create dropdown inside the widget Image 1 Screenshot 20

    Regards.