-
cynthialionsgiraudDemandé le 8 novembre 2023 à 09:27
Bonjour,
Comment faire un calcul additionnel dans un tableau de saisie à plusieurs colonnes (chaque colonne correspond 1 valeur) ?
Merci,
-
Shirized Jotform SupportRépondu le 8 novembre 2023 à 11:52
Hi Cynthia,
Thanks for reaching out to Jotform Support. Unfortunately, our French Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in French, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.
Now, let me help you with your question. Do you want to add a calculation value to each column in your Input Table and calculate it via the Form Calculation widget? If so, let me show you how:
- In Form Builder, select your Input Table’s gear icon to open the Properties.
- In the property's pane on the right, go to Options at the top.
- Enter your calculation values according to your table’s dimensions.
Since you've already added the Form Calculation to your form, you just need to add the Input Table for your calculation. Here's how:
- Select the Form Calculation widget’s gear icon to open settings.
- In the settings pane on the right, select Add Field, then choose your Input Table.
- Select all the sub-fields to use in your calculations.
6. Lastly, complete your formula, then select Save at the bottom once you’re done.
Here's a sample result:
You might also want to check out this guide Performing Calculations With Input Table for more information.
Give it a try and let us know how it goes.
-
cynthialionsgiraudRépondu le 10 novembre 2023 à 07:18
Thank you very much for your quick and complete response
Unfortunately, the score is not calculated.
The points for each line are 0,1,2,3,4 (never, rarely, sometimes, often, always)
-
Gaetan_BRépondu le 10 novembre 2023 à 07:43
Hello Cynthia,
Thank you for getting back to us. I have made a test on your form and the calculation seems to happen without issues:
Everything seems to be working now. Let us know if there’s anything else we can help you with.