Input Tables and filling some cells with predetermined values

  • Profile Image
    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? 

    Screenshot
  • Profile Image
    David
    Answered 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.

  • Profile Image
    FnG1991
    Answered on June 24, 2019 at 01: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?

  • Profile Image
    Alan_D
    Answered on June 24, 2019 at 03:27 PM

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