JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Calculating Certain Fields in MatrixAsked by RogerYelvington01 on April 06, 2015 at 09:54 AM
On this form: http://form.jotformpro.com/form/50416867039965
I need to accomplish 4 calculations that use the 10 "Membership Sold" input box fields:
1. Down Payment Total Calculation:
I need for the "$ Down Payment" field to be added up from all 10 boxes and calculated at a summary in the bottom.
2. Member Contract Total Calculation:
I need the "$ Contract Total" field to be added up from all 10 boxes and calculated at a summary in the bottom.
3. $ Dues Rate, Average Calculation:
I need the "$ Dues Rate" field to be averaged from all 10 boxes and calculated at a summary in the bottom.
4. # Member Term, Average Calculation:
I need the "#Member Term" field to be averaged from all 10 boxes and calculated at a summary in the bottom.
This is so important to our process, and I am trying to present this form to my managers this afternoon. Any help is appreciated, thank you very much!
calculations payment total 3 all
Unfortunately, you can't fetch or update certain fields in the Matrix field. What I would recommend is that you convert those fields into simple or plain text boxes. With that, you can pass the value and sum them all up.
You can then use the Form Calculation widget to sum up all the text boxes with values on them. Here's a guide on that: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form.
Do let us know if you need more help on this.
If you have received multiple email notification from this reply post, please do accept our apologies, we had a temporary hiccup on the server that posted the replies multiple times.
Again, apologies for the inconvenience.