Input Table Calculations

  • princess5510
    Asked on February 24, 2021 at 2:41 AM

    So this is a form that works properly for time sheet calculation:

    https://www.jotform.com/build/210524397919059

    However,

    i cloned this form but in my form in my input details i also want information such as date and attendance.

    this is the form im working on

    https://www.jotform.com/build/210541310182439

    If i add more details ( columns) into my input column, my timesheet calculation fails.

    The result table doesnt seem to extract the same information from the input table to do the calculation.

    Please help.


  • Fernand Enterprise Operations Specialist
    Replied on February 24, 2021 at 7:50 AM

    Hello princess5510,

    Thanks for reaching us.

    I cloned your first form(210524397919059) and added the new columns by changing the Input Type. So that, the calculation wasn't affected by the new columns.

    Check my screencast below:

    1614170621 603649fd187e0 Input table Screenshot 10

    To change the Input Type, please follow the steps below:

    1) Click on the Gear icon and navigate to the Fields.

    2) Select the Multi Type Columns.

    1614170794 60364aaa59eb7 Screen Shot 202 Screenshot 21

    3) Re-arrange the Column Types and Dropdown Options.

    1614170962 60364b52086bf Screen Shot 202 Screenshot 32

    Please have a try and let us know for further assistance.