I am using an Auto-Number column in my sheet to generate a new Request ID with every entry. I noticed this morning that there are duplicates of the same Request ID in the sheet. This is a concern because the RQID needs to be unique for each record.
There are two ways a record is created with the sheet. One is if a user leverages a web form to submit a request. The other is when a trained user (there are only a few shared to the sheet) enters a new record and saves it.
When I first created the sheet, I did consolidate multiple sheets into one, and made sure all the ID's were unique. However since then, the column has been locked. And because it's an Auto-Number column anyway now, I don't understand why a record I created this morning would generate a RQID-017 when one with that number already exists in the column.
Thoughts from the community?
