Forum Discussion

BrianDunk's avatar
BrianDunk
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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew 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
------------------------------