Calculation values represent the numerical value of an input field. It is generally used for conditional logic and form calculations. This feature is supported in Dropdown, Single Choice, and Multiple Choice form elements.
To assign calculation values
- In the Form Builder, select your form element’s gear icon to open properties.
- In the properties panel on the right, go to Options at the top.
- Turn on Use Calculation Values.
- Under Calculation Values, enter your field options’ numerical values.
You can enter the value for each row or paste a set of line-separated values from your clipboard.
You can now use your dropdowns, radio buttons, or checkboxes in form calculations and conditions. See how it works in this demo form.
Send Comment:
51 Comments:
11 days ago
quel est la formule de 10% du montant si le montant est inferieure de 150000, et de 6% sur le montant est superieur de 151000 ?
36 days ago
If answer is no to a question I don't want them to be able to move forward in the form. How do I do that?
66 days ago
I am having difficulty with the calculation widget on my newest form, The Brief Experiential Avoidance scale. I click on all of the fields in the Form Calculation Widget, but when I click on select a response for each item, it is returning a scientific number. What am I doing wrong? In the example, I see a need to add a + after each row, but when I try to do this it just adds the + at the bottom of all the rows. Please explain what I am doing wrong and how to do this correctly. Thank you.
79 days ago
What if I don't want the form submission to have the text choices but the calculation values instead? (easier to compile in a spreadsheet)
114 days ago
Yes, I am so glad you can paste a set of line-separated values from your clipboard! Thank you
166 days ago
In the pet grooming app booking form query there is no option to add timescales? Different levels of grooming take different lengths of time?
I need it to auto select up to two hours if a full groom is selected or 15 minutes etc if just a nail clip is selected?
the only only provided is a numerical option for cost? This option also would be handy if generated at the time of viewing on the booking form?
184 days ago
How do i review the score of a completed form?
218 days ago
RE: How to Assign Calculation Values
What if there was a product category for hats, t-shirts, and shoes each with three different calculation value options. How do you add the calculation values from each product category in that scenario? How do you add the values together? Is there a template demonstrates this
241 days ago
I'm having problems with trying to add my column values to produce a total score at the bottom of my form. I have watched the videos and tutorials but the calculation is off and is not adding the sum columns. Please help.
280 days ago
オプションの上限を2件に指定して、表示を定員になりましたとするための方法を教えてください。
More than a year ago
Good day, I want to create a form that provides an adjudicator with the option of assigning a number from 1-10 for the each of the questions related to the nomination, then multiplies that number by a percentage of overall value that that question is assigned, and adds up each of the categories at the end of the form
More than a year ago
I'm having the same issue as Miranda Meadow below. The downloaded data only have the text answers, not the numeric values.
More than a year ago
Is there a way to include the value in the form? So when someone selects deluxe package, it inputs the value (the dollar amount) into the form below (the contract).
More than a year ago
I assigned calculation values to this but the downloaded data only have the text answers, not the numeric values
More than a year ago
Am I correct that calculation values do not support variables like the field Unique Name? I'd like to reference another field in the calculation by entering {field}.
More than a year ago
We have updated using this feature, but the values are not reflected correctly in the data coming from the webhook. Can you help?
More than a year ago
I have been assigned a form, and I would like to make some modifications and add additional widgets to enhance its functionality. Could you kindly guide me on how to edit the form to implement these changes effectively?
Furthermore, my main question revolves around calculating the average for certain questions in the form without having the "N/A" responses impact the overall score. Is there a way to exclude "N/A" values from the calculations while still obtaining an accurate average for the relevant questions?
More than a year ago
I need total values for every cell in (Fields configuration) How ????
More than a year ago
Hello! My team wants to ensure that we can list out a list of multiple "subverticals"
based on which "verticals" are checked (whichVerticals22)
Reason is the list can get extensive and we only want the users to see the subverticals relevant to their earlier selection, BUT we want to include all the subverticals associated with earlier checkbox choices displaying and selectable.
I short - vs our setup now - we want to have the same functionality in terms of conditional dependent visibility, BUT have all the views be within ONE - not multiple - fields - so we can map it to our salesforce.
Seems like the visibility logic only enables showing or hiding questions, not differentiating what choices are shown in that question?
If thats case how is this achieved - calculations? (Not even sure a calculation can be the source of dropdown choices on jotform, plus there must be better ways than that.
Thanks so much!
Michael Attea
More than a year ago
Will it calculate the values in the backend somewhere when form is submitted?
More than a year ago
HI, I need a bit more clarification on the value calculation feature. I have 8 options (classes) and the capacity for each is 12 (except for rug weaving - the capacity for that class is 10). I need to know that students will not be able to register for classes that reach their capacity. Thank you.
More than a year ago
My form is not adding up correctly... can you please advise?
More than a year ago
Hola!
Quiero saber si puedo clisificar las opciones de respuesta y que al final cada oersonoda que responde el formulario obtenga un porsentaje de cada clasificacion
More than a year ago
Uso l'opzione calcola in un questionario di gradimento per cui ad ogni risposta associo come valore 10 o 0; quando però l'utente seleziona un'opzione come "non saprei" io inserisco nella domanda punteggio nullo, ma il sistema inserisce comunque come punteggio 0 e mi sballa la media.
Come posso sostanzialmente dirgli che deve ignorare quella risposta?
Grazie!
More than a year ago
Very powerful form I like it very much reallyyyyyyyy....................