Input Table Calculations

  • Profile Image
    princess5510
    Asked on February 24, 2021 at 02: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.


  • Profile Image
    Fernand
    Answered on February 24, 2021 at 07: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.gif

    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

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

    1614170962_60364b52086bf_Screen Shot 202

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