- ronak2303Asked on May 28, 2017 at 08:47 PM
is there any way i an create drop down in Spreadsheet Widget.
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 SupportChriistianAnswered 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.
- ronak2303Answered 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.
- JotForm SupportChriistianAnswered 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.
- ronak2303Answered on May 29, 2017 at 01:47 AM
i am trying to get something like "Configurable List" but with amount total.
- JotForm SupportChriistianAnswered 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.