- vcmimediaAsked 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.
- JotForm SupportChriistianAnswered on November 22, 2016 at 10:14 AM
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.