Form grid with calculated field not saving properly (seems a bug)
I have a form grid with a calculated field. Before saving the form everything looks great. But after saving the data it saves all field correctly except the calculated fields, It takes the first value of the calculated field (first row) and saves the value in all the records ignoring the calculation.
For example I downloaded the Simple Purchasing sample app from Joget marketplace (https://marketplace.joget.org/jw/web/userview/mp/mpp/_/vad?id=APP_purchasing-v1). the below images will explain the problem of what seems a bug:
- the below screenshot is for the form where we added items and before saving the form:
2. Now the below screenshot is for the form grid after saving the data (submitting the form). You can see that the total fields have all the values of the first calculated field.
The above can be reproduced by downloading the Sample App mentioned above form the Marketplace. The problem is actually in the process of saving the data (not loading) as I have checked the table and actually it has the same wrong values!
Any help?