Forum Discussion

BrianDunk's avatar
BrianDunk
Qrew Cadet
2 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 on a different record?  Also, check only if a checkbox is not checked?  If the checkbox is checked don't check at all.

Thanks
Brian

------------------------------
Brian Dunk
------------------------------

7 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    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's avatar
      BrianDunk
      Qrew Cadet
      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's avatar
        MarkShnier__You
        Qrew #1 Challenger
        looks right to me, give it a try.

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------