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...
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.