AnsweredAssumed Answered

Detect duplicate entry of data in portal

Question asked by Scott Van Nostrand on Aug 7, 2014
Latest reply on Aug 28, 2014 by Scott Van Nostrand

Title

Detect duplicate entry of data in portal

Post


     I have users entering data in portal via a handheld scanner. All the  entries must be unique and they can easily re-scan the same number by mistake. After each scan I want to review the previous scans in that scanning job and detect if they have previously scanned that number.

      

     My strategy was/is to count the number of records with the previous scan and delete it if > 1 (if I commit the record or if 0 records if not committed).

     Should I use and ExecuteSQL script statement to test for this or freeze the screen and do a find, count records...

      

     Other quicker strategies to detect a duplicate field entry in two different portal records?

Outcomes