Spreadsheet Widget: Create dropdown inside the widget

  • Profile Image
    ronak2303
    Asked on May 28, 2017 at 08: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.

  • Profile Image
    Chriistian
    Answered on May 28, 2017 at 09: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:

     

    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.

     

    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.

     

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

     

     

     

  • Profile Image
    Chriistian
    Answered on May 29, 2017 at 01:25 AM

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

    So it should look like this:

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

  • Profile Image
    ronak2303
    Answered on May 29, 2017 at 01:47 AM

    hi, 

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

  • Profile Image
    Chriistian
    Answered on May 29, 2017 at 01: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.

    Regards.