Calculate values in Input Table using Calculation Widget.

  • Profile Image
    vanessa126
    Asked on January 29, 2021 at 01:48 PM

    Hi there !

    I'm struggling with the table in this form. I need a total at the end of each row according to the numbers selected in the dropdown menu. Is that possible at all?

    If not, can you help me figure out another option?

    This a form that is filled by an onsite contractor, whom lists all the men that worked on his job that week and how many hours per day. We need the total for each mean and then the total for the hours for that job on that week.


    Thank you so much!


    Vanessa

  • Profile Image
    Amin_N
    Answered on January 29, 2021 at 07:04 PM

    Thanks for reaching out to us!

    To my understanding, what you're after is having respondents choose numbers from drop-downs in a table and have the total of them presented on form.

    That said, kindly note that you may perform calculations on entered values in Input Tables as shown below.

    1) Add an Input Field and Calculation Widget as shown below.

    1598800984screenshot-www.jotform.com-202

    1611964964_6014a224f1480_1602875399_5f89f0070a8c3_

    2) Choose which Input Table cells you wish to involve in the calculation.

    1602875421_5f89f01d18ab0_

    3) Set the calculation.

    1602875305_5f89efa9ef7f0_

    Result:

    1602875508_5f89f07484078_

    My simple demo form: https://form.jotform.com/202895455611055

    Related guide: How-to-perform-form-calculation-in-the-input-table-field

    I hope I've been of help.

  • Profile Image
    vanessa126
    Answered on February 04, 2021 at 10:22 AM
    Hi there,
    Thanks for the information, unfortunately those fields are very big, and I’ve got quite the list to go through, sometimes there are more than 20 employees on the job. Is there not a way to calculate what’s in that row and add it on at the end?
    Also, do you have the conditional option to make a field appear if a certain box is checked?

    Thank you !
    Vanessa
    _____________________
    Alliée Virtuelle - Déléguer pour optimiser!
    [cid:953158B9-CDB8-4B08-874C-2703F8DA39ED@home]
    ...
  • Profile Image
    Bojan_J
    Answered on February 04, 2021 at 12:35 PM

    Greetings Vanessa.

    An alternative solution would be to use the Spreadsheet widget. This will give you a simplified version of Excel where you can calculate the totals. You can see an example here:
    https://form.jotform.com/52644223831956

    To learn how to use this widget, please use the following link:
    https://www.jotform.com/help/598-how-to-set-up-the-spreadsheet-widget

    Let us know if you have any additional questions.

  • Profile Image
    Bojan_J
    Answered on February 04, 2021 at 12:44 PM

    I forgot to address your second question.

    We are working on the reply and you will receive it soon at the following link:
    https://www.jotform.com/answers/2874661

    If you have any additional questions, please post them to associated tickets.

    Thank you for your cooperation.