Forum Discussion
Forms for Excel results duplicating in Excel online
Hi, I'm having some issues with results duplicating by itself non-stop every time a user submits a response. Basically, when a user submits a response, the Form writes to the Excel workbook and p...
No, the ID of each response is unique. Per say I clicked submit button 5 times at the completion of a Form, it will create 5 same responses and mark it with continuous number such as ID: 1, 2, 3, 4, 5. Just like in database, when you mark the primary key column auto-increment.
Sean_Shen what I am seeing has the same ID. In your instance, you see 1,2,3,4,5. I am getting 1,2,3,4,5,4,5,4,5,3,4,5,4,5,3,3,3,4,4,4,5,5,5,5. No pattern, just random duplication.
I see where adding "Only allow one response" would stop your issue. But, what I am seeing needs a validation rule in the database entry system. The one thing I am seeing is it skipped entry "1185". It seems to be trying to reload from there each time.
- no official response from microsoft yet. to date the issue persists.
