How to calculate Input Table Entries

  • HealthStaff Training Institute
    Asked on March 27, 2023 at 9:31 PM


    I'm using time sheet form template:

    I need to calculate the sum of hours worked each day for the whole week. (the number of hours worked is a field input by the employee)

    How to achieve this?

  • Myla JotForm Support
    Replied on March 28, 2023 at 4:04 AM

    Hello HealthStaff Training Institute,

    Thank you for reaching out to Jotform Support. Yes, it is possible to add calculations on Input Table. Just to confirm, you mentioned that you only wanted to add hours per week, right? If so, you can adjust the fields in your Input Table to calculate. Let me show you how:

    • Form the form Builder, go to Settings and click on the Conditions Tab on the left panel
    • Click on Update/Calculate Field and set the assigned conditions
    • Click on Save

    1679990527 64229effe7da9  Screenshot 10

    Here is a screencast of how I've done it on a sample cloned form, feel free to clone and inspect:

    1679989685 64229bb52fd46  Screenshot 21

    If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

  • daniielllisa
    Replied on March 28, 2023 at 4:07 AM

    Nice post