1. What is the issue? Please be detailed.
I am trying to prevent duplicate entries inside a repeat group. I created a unique key using concat() of three fields, but the validation count() is not working in KoboToolbox/ODK Collect.
2. What steps can we take to reproduce this issue?
Add an item in the repeat group (e.g., Product A, Size 1), then add another item with the exact same details. The form should show a warning or block the entry, but it doesn't.
3. What have you tried to fix the issue?
I have used the formula: count(../capture_items[prod_pack_key = current()/prod_pack_key]) <= 1 in the constraint column. I have also tried putting it in the relevant column for a warning note.
inventoryrequest (1).xlsx (582.6 KB)
4. Upload any forms or screenshots you can share publicly below.