Duplicate entry ... for key 2 error
I spent two or three hours wrestling with a form that would generate a "Duplicate entry ... key 2" error (reported many times in this forum) often when submitted. I had no fields marked as "No duplicate entries", so naturally I've learned to figure that ZC is messed up somehow and throwing the error for some bizarre or illogical reason. So after many experiments, I finally discovered that the error message was being thrown because the last character of the strings in a checkbox list ended in a number (0-9). I learned that by ending the checkbox strings w/ any alpha character solved the problem.
So, after losing a valuable afternoon of my life, it came down to a bug in Zoho Creator, not in my code or design. I'm posting this in case it helps dev figure out what's with the oft-reported 'Duplicate entries... key 2' error.
---
Greg
aka datazen1
aka w21admin
Santa Fe, New Mexico