Is there a way to allow duplicate numbers in a form submission for AppSheet?

[sectionalmedia]

I am just entering data to a spreadsheet from a form app on AppSheet, but I want to allow duplicates in case the spreadsheet isn't cleared before the next use. 

We are using it to collect when students have a meal at each meal, and to just allow us to scan the ID then it records the ID on the spreadsheet. But if the data is not cleared before the next meal, it wont allow the duplicate number. Which is fine because we would just charge them for every meal they have.

So on my columns I just have SKU and DATE which I have NOW() for the equation. So it submits the Sku and places the date and time it was scanned. I have it set to automaticaly sumbit when the sku is filled out with a scanner and reopen the page when it finishes submitting.

[EliK]

Is the number you are using the key column of your table? If so, that's why it's not allowing duplicates.

Make sure to use a separate column as your key (with initial value of UNIQUEID() and it should be fine.

[sectionalmedia]

They are ID numbers, so it would be in the same column, just as if you were on a spreadsheet scanning barcodes down the column. But it doesnt allow that from the app.

I did try the Unique ID but then it doesn work where they can just scan the ID and it submits. Plus it would be fine if the numbers are duplicate. 

[sectionalmedia]

I think I fixed it, I unticked the KEY check and it allows it now.

Thanks!