Checking for Duplicates in a Field in Other Records

Question

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

markshnier__you · Answer

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 · Answer

Hey Mark quick question on this.&nbsp; 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?&nbsp;&nbsp;The code currently is the following:var text QUERY = "{6.EX." &amp; [Container Number] &amp; "}";var bool LookForDuplicates = Size(GetRecords($QUERY))&gt;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&nbsp;Brian------------------------------Brian Dunk------------------------------

markshnier__you · Answer

looks right to me, give it a try.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

briandunk · Answer

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.&nbsp; Can you tell me if this would be correct?var text QUERY = "{6.EX." &amp; [Container Number] &amp; "}";var bool LookForDuplicates = Size(GetRecords($QUERY))&gt;1;If([Domestic]or[Consolidated Shipment]=false, $LookForDuplicates)------------------------------Brian Dunk------------------------------

markshnier__you · Answer

If there is an error you need to copy and paste the error.As for the logic, can you say in words when you want to check for duplicates?&nbsp; Under what conditions?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Checking for Duplicates in a Field in Other Records