Input Tables and filling some cells with predetermined values

  • FnG1991
    Asked on June 24, 2019 at 11:07 AM

    I want to create a form with a fillable budget, using an input table. I want the user to be able to fill most detail of items and income but I would also like to be able to have some pre-determined values in the table.


    For example, as you'll see in the attached excel sheet, in an income budget I want to be able to show Sales and sponorship as headings but then for the user to fill in items below that.


    Is there a way of doing this with an input table? 

    Jotform Thread 1867806 Screenshot
  • David JotForm Support Manager
    Replied on June 24, 2019 at 12:35 PM

    There is a way, but not with the Input Table, instead, you would need to use the Spreadsheet widget, which allows to set up calculation formulas: https://widgets.jotform.com/widget/spreadsheet

    Please give it a try, and let us know if you need more help.

  • FnG1991
    Replied on June 24, 2019 at 1:27 PM

    I know the spreadsheet widget, that’s not what i want to use though.


    i want to use the table so I can make automatic calculations further on in the form, which spreadsheet doesn’t allow.

    is there an alternative?

  • Alan_D
    Replied on June 24, 2019 at 3:27 PM

    Unfortunately, the input table does not support the default content.