My question relates to auto-verifying records which are being treated as device replacement applications/orders which are either approved or denied. The system should work on it’s own, uploading “approved” records on to our separate order management system on its own.
I’ve managed to get verification codes working, but I’m struggling to find a way to identify whether a newly created record contains the same device serial number as a previously entered record which was approved for replacement. Basically, I want to say IF a previous record with this serial number already exists THEN mark status field as Denied.
I’ve considered making the serials the primary field, but in that case if an application was placed into the table via our Typeform plugin that had the same serial, wouldn’t it create an error?
Appreciate any help! Hoping there’s a smart way to do this.