Advice needed for creating an expense sheet

  • Andrea Chisolm
    Asked on December 3, 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


  • Welvin Support Team Lead
    Replied on December 3, 2020 at 3: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