Dear Concerned Team,
I hope this message finds you well.
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.
Best regards,
Hasib
DLR 2.2 DistributionMarketing Data.xlsx (44.1 KB)
