Calculation in Input Table.

  • cynthialionsgiraud
    Demandé 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 Support
    Ré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:

    1. In Form Builder, select your Input Table’s gear icon to open the Properties.
    2. In the property's pane on the right, go to Options at the top.
    3. Enter your calculation values according to your table’s dimensions.

    Calculation in Input Table Screenshot 50

    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:

    1. Select the Form Calculation widget’s gear icon to open settings.
    2. In the settings pane on the right, select Add Field, then choose your Input Table.
    3. Select all the sub-fields to use in your calculations.

    Calculation in Input Table Screenshot 61

    6. Lastly, complete your formula, then select Save at the bottom once you’re done.

    Calculation in Input Table Screenshot 72

    Here's a sample result:

    Calculation in Input Table Screenshot 83

    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.

  • cynthialionsgiraud
    Ré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_B
    Ré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:

    Calculation in Input Table Screenshot 20

    Everything seems to be working now. Let us know if there’s anything else we can help you with.