How to calculate a column on input table?

  • Profile Image
    Farren_Maria
    Asked on February 01, 2021 at 03:25 PM

    on page 3 of my form https://www.jotform.com/203493984454062 as you see I have an input table that asks for occupation, employer then annual income for mother/father in the last column.

    is there a way to calculate the numbers in the last column to total so i have a "total annual income" cell in the table? also can i get the income column to be $ while the other columns are text?


    thanks!

  • Profile Image
    Jed_C
    Answered on February 01, 2021 at 09:22 PM

    Is there a way to calculate the numbers in the last column to total so I have a "total annual income" cell in the table? — You will need to add a form calculation widget and capture the value for annual income column. Once you have the total, you can copy the value and inject it into your total income row.

    Sample screencast:

    1612232385_6018b6c16c900_input_table.gif

    Also can I get the income column to be $ while the other columns are text? — You just need to add a $ symbol into the condition. Please watch my screencast below.

    1612232514_6018b74228133_dollar.gif

    I hope that helps. Let us know if you have any questions or if you need further assistance.