Calculer une valeur pour chaque ligne

  • Julien_Compain
    Demandé le 2 août 2023 à 02:34

    Calculer une valeur pour chaque ligne Image 1 Screenshot 20

    Comment pour chaque ligne calculer "longueur" x "hauteur" dans "Surface" ?

  • Bojan Support Team Lead
    Répondu le 2 août 2023 à 06:48

    Hi Julien_Compain,

    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. Unfortunately, it is not possible to have calculations in Configurable List widget. The alternative solution would be to use the Input table:

    Calculer une valeur pour chaque ligne Image 1 Screenshot 80

    To get started, you first need to add a calculation widget from the Widgets tab for every value you have:

    Calculer une valeur pour chaque ligne Image 2 Screenshot 91

    In every calculation, you will need to select a related field:

    1. Open Widget settings of the first calculation
    2. Click on the Add Field button
    3. Select your Input table
    4. Select the first field
    5. Click on Done and save the changes

    Calculer une valeur pour chaque ligne Image 3 Screenshot 102

    Now, we need to configure the calculation condition to get the final value:

    1. Click on the Settings at the top orange bar
    2. Select Conditions from the left menu
    3. Click on Update / Calculate field

    Calculer une valeur pour chaque ligne Image 4 Screenshot 113

    1. Then, check if the first two related fields are filled
    2. Multiply them to get the final result
    3. Select the related field in the input table where the result should be shown

    Calculer une valeur pour chaque ligne Image 5 Screenshot 124

    You will have to repeat this for all other fields.

    Calculer une valeur pour chaque ligne Image 6 Screenshot 135

    You can also hide the extra calculation field on your form so they are not visible to your users. You can simply right-click on them, and select Hide.

    Calculer une valeur pour chaque ligne Image 7 Screenshot 146

    You can check out my example form here. Feel free to clone it to your account to see it directly in the builder.

    Let us know if there’s anything else we can help you with. 


  • Julien_Compain
    Répondu le 2 août 2023 à 10:01

    Thanks a lot for your answer, Bojan,

    First of all, I appologies, I sent my help requet 3 times on the website and another one by the chat.

    To defence myself, both of them dont work very well, the website desplayed an error messsage and the chat kept appearing and deseapering.


    Now problem is with the input table, the user cannot add as many rows as he need.

    How do you manage that ?

  • Mohammad_D
    Répondu le 2 août 2023 à 12:05

    Hi Julien,

    Thanks for getting back to us. As for your other question, I've moved that to a new thread. It will be answered shortly here.