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