JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Good Morning, Is it possible to create a balance sheet in JotForms?Asked by vcmimedia on November 22, 2016 at 09:22 AM
I want to create a sheet where you input a grand total and then when portions of that total are distributed it shows the calculation and balance. I also want to be able to add amounts to the current total and the date it was added.
You can try to add a Spreadsheet widget in your form: https://widgets.jotform.com/widget/spreadsheet. Using the Spreadsheet widget, you can perform calculation or add formula on each cell just like in Excel. You can check the demo of the widget here: https://form.jotform.com/61441655557965.
You can also add a calculation field in your form using the Calculation Widget: https://widgets.jotform.com/widget/calculation. For more information about the calculation field, you can check this article: How to Perform Calculation in the Form.
Do let us know if you need further assistance.