Checking for Duplicates in a Field in Other Records
How would I check to see if a field has the same value in the same field in other records after clicking Save and Close? Can a pop up show saying the field on this record is a duplicate to the field ...
Hey Mark quick question on this. If I wanted to add another checkbox to my form to control whether to check for duplicates or not could I add the following code to my "Dupicate" formula field? The code currently is the following: var text QUERY = "{6.EX." & [Container Number] & "}"; var bool LookForDuplicates = Size(GetRecords($QUERY))>1; If([Domestic]=false, $LookForDuplicates)
Could I add the following to add another checkbox called "Consolidated Shipment" to control whether to look for duplicates? If([Consolidated Shipment]=false, $LookForDuplicates)
Thanks Brian
------------------------------ Brian Dunk ------------------------------
Hi Mark, so I tried adding that IF statement and it gave me an error so I went with the following but I am not so sure it is working as I hoped. Can you tell me if this would be correct?
var text QUERY = "{6.EX." & [Container Number] & "}"; var bool LookForDuplicates = Size(GetRecords($QUERY))>1; If([Domestic]or[Consolidated Shipment]=false, $LookForDuplicates)
------------------------------ Brian Dunk ------------------------------
Ok...when I have the code as the following I get this error: var text QUERY = "{6.EX." & [Container Number] & "}"; var bool LookForDuplicates = Size(GetRecords($QUERY))>1; If([Domestic]=false, $LookForDuplicates) If([Consolidated Shipment]=false, $LookForDuplicates)
So then when I change to this: var text QUERY = "{6.EX." & [Container Number] & "}"; var bool LookForDuplicates = Size(GetRecords($QUERY))>1; If([Domestic]or[Consolidated Shipment]=false, $LookForDuplicates)
Now when I select the "Domestic" checkbox it will not allow me to save. I thought, with the code above, if I checked the either checkbox it would turn off the duplicate checking.
I only want to check for duplicates when both the "Domestic" or "Conslolidated Shipment" checkboxes are NOT checked. If either one is checked, do not check for duplicates.
------------------------------ Brian Dunk ------------------------------
