What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Spreadsheet Widget: Create dropdown inside the widget

    Asked by ronak2303 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.

    Screenshot
  • Profile Image
    JotForm Support

    Answered by Chriistian 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

    Answered by ronak2303 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
    JotForm Support

    Answered by Chriistian 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

    Answered by ronak2303 on May 29, 2017 at 01:47 AM

    hi, 

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

  • Profile Image
    JotForm Support

    Answered by Chriistian 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.