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

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

Sign up

Login to the community