- coachleeAsked on October 13, 2015 at 05:06 PM
Id like to add up the values inserted in 3x fields and display it in a forth for each row of a matrix grid.
Im basically creating a stat sheet which i can embed to my basketball club's website to allow team admin members to enter stats of their game scoresheets.
This is a re-post of a comment on Form Calculation - Math Function Reference
- JotForm SupportjonathanAnswered on October 13, 2015 at 10:21 PM
Unfortunately it cannot work that way. It is not possible yet to use the specific Matrix cell as the recipient of Calculation results.
What you can do at this time is to use another separate field (Textbox will do), as the target container for the result.
Here is an example on what I meant
Let us know if you need further assistance.
- JotForm SupportjonathanAnswered on October 13, 2015 at 10:23 PM
Another option you may want to check is using the Spreadsheet Widget
here is the demo form http://form.jotformpro.com/form/51730795061960?
If you test the form, you can see that it was able to calculate values of the cell and display the result on another cell within the spreadsheet.