Forum Discussion

Qrew Cadet

4 years ago

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 ...

formula queries

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

4 years ago

try this as a formula Checkbox field type. Replace the 232 with the field which is the potential duplicate and of course use your own fields in the square brackets.

var text QUERY =
"{232.EX." & [Possible duplicate field] & "}"

var bool LookForDuplicates =
Size(
GetRecords($QUERY)) >1;

IF([my checkbox field]=false, $LookForDuplicates)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

BrianDunk
Qrew Cadet
4 years ago
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
------------------------------
- MarkShnier__You
  Qrew Legend
  4 years ago
  looks right to me, give it a try.
  
  ------------------------------
  Mark Shnier (Your Quickbase Coach)
  mark.shnier@gmail.com
  ------------------------------
  - BrianDunk
    Qrew Cadet
    4 years ago
    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
    ------------------------------