Forum Discussion
Forms for Excel results duplicating in Excel online
I created a test form and shared it with anyone can answer permission to myself. When I finished the form, by clicking the submit buttom multiple times before it redirected to the completed interface, the problem can be reproduced. For anyone in your orgnization permission, it actually has a choice that distincts the response that eliminates the duplicates. However, that option is not available to permission "anyone can answer". The problem is if I want a lot of people in the company to answer a form, having them login first will just stop them from answering the form.
In conclusion, I think it is a design issue and I guess Microsoft will not fix this or add a "one response from each user" option to "anyone can answer" permission in a short time.
Were the duplicate entries receiving the same ID number as well?
What we were seeing was the same entry occurring multiple times throughout the day (i.e. I submit the form in the morning, 30 minutes later, 2 hours later, 2 hours 5 minutes later, etc. the same submission is entered again in the table). This continued throughout the day. Then, close to the end of the day, a new spreadsheet popped up in the SharePoint Excel file. Now, this new file is doing the same thing.
- 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.
