I have created an scavenger hunt App where the users needs to find a checkpoint, when they find it the scan a QR code and the app sends to Airtable their unsername connected to the name of the check point found. Winner is the one which has most points in total (which means that they found more check points)
here is how the table looks https://airtable.com/shrZkdykmqmIMHMAc
My issue is when a user scans twice the same QR code which results in a double entry in the table.
Is there a way to overwrite the data which are automatically sent to Airtable? or eventually an automatic way to delete double entries connected to a user?
I am not so good with airtable, so it might be a super easy thing to solve, but I’m not able to figure it out… any help is greatly appreciated.