The Input Table element can be found in the Basic tab of the Form Elements panel.
In this guide, we will set up a survey questionnaire with ratings using the Input Table element and then calculate the total rating using the Form Calculation widget. Let’s start.
- Add an Input Table element to your form.
For the purpose of this guide, we’ll be using the Input Table’s default setup.
- Click the gear icon to open the properties panel.
- Go to the Options tab.
- Define the values in the Calculations Values field.
Note
The Calculation Values option only works on radio button and checkbox input type.
- For the calculations, add a Form Calculation widget to your form.
For more information, check out the “How to Perform Form Calculation Using a Widget” guide.
- Open the widget settings panel by clicking the wand icon.
- Click Add Field then choose the Input Table.
- Select the sub-fields to use in the calculations.
This will add the sub-fields in the calculation screen without operators.
- Complete the formula then click the Save button to save the changes.
Here’s a demo form with the setup above applied: https://www.jotform.com/221335927268461
Do you have questions about this guide? Please let us know in the comment box below or post it to the support forum.
Send Comment:
12 Comments:
Hello:
I'm using time sheet form template
I need to calculate the sum of hours worked each day for the whole week. (the number of hours worked is a field input by the employee)
How to achieve this?
I would like to assign one column as Not Applicable and have any row where a user selects Not Applicable excluded in an average score calculation. Is this possible?
great tool
bonjour équipe. superbe site. est-ce possible d'avoir une formule dont le résultat des calculs sort brut plutôt que de donner des résultats convertis au supérieur ou à l'inférieur? Merci
Hi, if i have form with calculation values applied to each answer, is it possible to total up all the answers then redirect to a different webpage according to the total?
How to put default (prepopulate) values in Column 1 and Column 2, the third column is a dropdown, and the forth column is a text input column. Is there a way to accomplish this?
How do I make the price automatically populate the cell after the customer selects the quantity of the product?
This is so great, but i need to know if its is possible to add formulas in this section like in excel so it calculates automutically?
This feature is not working for us. Though it is set up correctly, it will not perform the math function. It is like we are getting an average...
The instructions state the following:
Note: Choosing a different input type for the table, like a text box or number text box, if you want your respondents to define values for each cell, will not require you to set calculation values.
If this is the case, what if I want to use the dropdown box, how do I give each of the dropdown box answers a different value? For example I want the following dropdown values to equal the corresponding value.
Not at All - 0
A Little Bit - 1
Moderately - 2
Quite a Bit - 3
Extremely - 4
very very nice
Can more than one column be selected in each row?