-
nappalodgeAsked on August 23, 2017 at 4:43 AM
The spreadsheet widget is great and I can add up a list on calues in the right hand column and end up with a total in the bottom right hand cell. Can I use the value from this cell to feed into the form calulations widget, which is also great.
Irvin Metcalf
-
CharlieReplied on August 23, 2017 at 5:02 AM
Unfortunately, it is not possible to fetch the specific cell in the Spreadsheet widget and used in the Form Calculation widget.
However, you can use the "Input Table" widget to replicate the behavior in the Spreadsheet widget, you just need to use Conditional Logic to calculate the values in the cell. Then you can simply fetch the cell that holds the total calculation in the "Input Table" and insert it in a Form Calculation widget.
Below are two guides that might help you on how to accomplish this:
https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field
https://www.jotform.com/help/414-Calculate-Values-in-the-Input-Table-Through-Condition
I hope that helps.