Hello,
I am hoping for ideas, on how best to check for duplicates of a submitted form and what is possible to set up to avoid and stop this from happening.
Basically i want something that doesn't allow a form to be submitted if an identical/partial match of an already existing record is already present within the data source (which happens to be an excel spreadsheet).
I had the idea of maybe a check to see if some information is already present so a unique identifier like an employee number paired with a date field being recognised as already exisiting on the data source. Creating the duplicate flag.
Open to any idea/experience that anyone has with this though and the best way to prevent duplicates.
Thank you!
Chris


Report
All responses (
Answers (