Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
Hi,
You can put a calculation field in the form grid to calculate the 'Balance of Tax Payable". And if i may suggest, might as well you can put the Tax Payable and Tax Installment as the columns in the form grid.
I have also attach two sample apps for your perusal.
One is using form grid. :APP_calculateField-1-20240731063003.jwa
one is using Spreadsheet. :APP_spreadsheet_dx_kb-2-20240731063506.jwa
Thank you John for your help. I will see is there others alternative to do what i needed above.
Able to Edit Form Grid data using javascript?

Want to edit the formgrid data Set the Row " Balance of Tax Payable" to "22.00"