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.
How to set up calculations based on a Matrix field inputsAsked by SMFSNCU on October 09, 2015 at 06:39 AM
I checked your most recent form and it looks like you are still using Matrices rather than the Spreadsheet widget:
I believe my colleague explained the setup of the widget in your previous thread.
Sorry but I don’t understand the google spreadsheet. This seem cumbersome.
Alternatively, you might try conditional calculations with 'UPDATE / CALCULATE FIELD’S VALUE' conditional logic rules on form.
Here is an example for one Matrix row.
Note, that you will need to set calculation condition for each row.
Can you assist me with this please.
1. Edit your form
2. Click "Conditions" in the toolbar
3. Setup your conditions:
a. Set your Rule and click the "Add Field" button:
b. Select the Matrix field. For example, the travel expenses matrix:
c. Click "Show Headers" and select the options in a row that you would like to calculate except the Totals column then click "Insert" button:
d. Add + after each option. For example:
d. Select the Output To Field. In this example, I have selected the same matrix which is the "Trave Expenses". You have to select the last option in the row which is the total column:
That's it. Repeat the same for the other matrices.