Solved: Identifying if Product Code Exists - Page 2

MauriceWhelan · 07-19-2019 01:57 AM

I am building up a product file through a form and each product is entered through a unique QR Code. What expression can I use to check that the value of the scanned QR code does not already exist in the product file table and if it does I need to prevent the record from being submitted. The field in question is [Product Code].

Thank you.

Aleksi

Then you should be able to do it like… [Butt Min Diameter (cm)] < ANY(SELECT(YourExistingFormulaIn InitialValue)). You should have a situation where you check the condition like number against number.

View solution in original post