Advice needed for creating an expense sheet

  • Profile Image
    Andrea Chisolm 
    Asked on December 03, 2020 at 12:20 PM

    I have a list of services we provide and the price for each. Each service has an expense. What is the best way to do this?


    Below is my attempt at solving the problem but it is crude.


    https://form.jotform.com/203374986298068


  • Profile Image
    Welvin
    Answered on December 03, 2020 at 03:22 PM

    Hello Andrea,

    If it requires a table, we have the Input Table, which you are currently using in the form. If there's a need to calculate numbers, you can do it within the table, but through conditional logic.

    https://www.jotform.com/help/414-calculate-values-in-the-input-table-through-condition

    The calculation may be tedious considering the number of boxes in the table. However, it will work for your use case once set up correctly.

    Do you have a full picture of the expense sheet or a detailed explanation of how that works?

    You may also want to search for an existing template from our Template Gallery. That way, you'll get the idea of how to do such.

    https://www.jotform.com/form-templates/search/expense