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.
Configurable with CaclulationsAsked by lmaine on December 19, 2016 at 04:04 PM
I need to incorporate a survey that will calculate a total for each Subcontractor and also allow the participant to add as many Subcontractor's as necessary. Do you have any suggestions as to how I could do this?
Hello, from how you described it, you need 2 things:
1. A field that allows unlimited entry (as many as the user wants to add)
2. A way to tally the results of each column at the very bottom (just like the sheet shown on your screenshot)
I'm afraid there's no way to achieve them both. Each of them are doable though but not at the same time.
You can achieve #1 above using the Configurable List Widget (your current setup) but the calculation wouldn't work the way you want it to. There's no way to tally/compute the total of each column.
You can do #2 above if you'll use the Matrix Field, BUT it won't allow your users to add as many as they want. They can only go as far as to how many predefined rows you will set it up with.
The only way around this is to decide which way you'd go to - And IMO, it's better to go with the Matrix Field and just set an ample amount of rows for your users.
Related guide: How-to-Perform-Form-Calculation-in-the-Matrix-Field