Data overwrite for double entry

Topic Labels: Dates & Timezones
588 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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

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.

1 Reply 1
4 - Data Explorer
4 - Data Explorer

Any idea on how to solve it?
I still have not found a solution