I have created a form to monitor seed distribution across different zones or districts from a central seed store. In the form, I have set up a group for each zone, where the system calculates the total amount of seeds distributed. Within each zone group, there is a sub-group that tracks the number of memos used for the distribution and the total seed quantity for that specific zone.
When I enter data for just a single zone, the calculations for both the seed distribution and the total number of memos work correctly, and the validation messages appear as expected. However, the issue arises when I input data for multiple zones. In this case, a validation error message is triggered, which is preventing the form from functioning as intended.
I have attached the XLS form for your reference. The form includes both English and Bangla languages for better accessibility. I would appreciate it if you could take a look at the form and advise on the cause of the validation error when handling multiple zones.
Thank you for your time and support. I look forward to your feedback.
@testwbd, it would be easy for the community if you only share the portion of your XLSForm that has issues (or not working properly) instead of sharing the entire form.
I then quickly scanned your XLSForm (the survey sheet) and did not find any name ${Variety} under the name column header. But I could see that you have used it frequently under the label column header.
