Insert a formula so it calculates the total amount of Input Table values

  • Ypurchasing
    Asked on April 28, 2024 at 11:28 AM
    Insert a formula so it calculates the total amount
  • Norwyn JotForm Support
    Replied on April 28, 2024 at 11:38 AM

    Hello Ypurchasing,

    Thanks for reaching out to Jotform Support. Currently, the option to add calculation between entries within the Input Table widget is unavailable. You can use the Form Calculation widget as a workaround to calculate the total for the Input Table widget. Let me show you how:

    1. On the Build tab of your Form Builder page, click on the Add Form Element button on the left.
    2. Go to the Widgets tab and then look for the Form Calculation widget.
    3. Drag and drop it into the form.

    Insert a formula so it calculates the total amount of Input Table values Image 1 Screenshot 50

    Set up the formula.

    1. Click the Wand icon to open its settings for the formula.
    2. Then click the Add Field button and select the Input Table.
    3. Add the rows to the formula and then click the Save button.

    Insert a formula so it calculates the total amount of Input Table values Image 2 Screenshot 61

    So the formula must look like this;

    Insert a formula so it calculates the total amount of Input Table values Image 3 Screenshot 72

    Here is the result:

    Insert a formula so it calculates the total amount of Input Table values Image 4 Screenshot 83

    Here is a demo form I created, which you can clone for reference.

    Reach out to us again if you have more questions.

  • Norwyn JotForm Support
    Replied on May 8, 2024 at 6:22 AM

    Hello Ypurchasing,

    How is it going? Just sending a follow-up to see if you were able to get our previous message. If yes, please feel free to let us know so we can further check this for you. Meanwhile, I will be marking the thread as resolved since we have not received any response from you.

    Reach out to us again if you have more questions.

  • Ypurchasing
    Replied on May 15, 2024 at 3:46 PM

    Hi there! I think the whole table got messed up.

    When I preview and test I am not able to fill it out. Can you please help?


    Insert a formula so it calculates the total amount of Input Table values Image 1 Screenshot 20

  • Kim JotForm Support
    Replied on May 15, 2024 at 6:26 PM

    Hi Ypurchasing,

    Thanks for getting back to us. When I checked your form, I found out that the table is being filled out, but the text color is white, that's why it looked like it's not being filled out. I checked your CSS codes and can see that it was added, but it's not being applied. Please remove the previous CSS codes and add at the bottom part of your CSS codes.

    #id_28 {
        color : black!important;
    }

    Checkout my screencast below to see:

    Insert a formula so it calculates the total amount of Input Table values Image 1 Screenshot 20

    Give it a try and let us know how it goes.

 
Your Answer