Remove Old Form Entries
I have a sheet where users scan a barcode into a form. I would like the sheet to remove the old entry if the barcode is scanned again.
So, user scans in 1234 with a note "Checked out"
The then scans the same 1234 barcode in with a note "Checked in"
I want to to drop the first "Checked out" row or move it to another sheet.
Any help would be appreciated.