Forum Discussion

JoshuaDavis1's avatar
JoshuaDavis1
Qrew Cadet
7 days ago
Solved

Allowing Duplicate Entries

Hi, What is the proper work around to allow duplicate entries with a field being marked as "Must Be Unique"? Thanks!  
  • MarkShnier__You's avatar
    7 days ago

    An easy way to do this is to make a formula field like this below along with a checkbox field called [Allow Duplicates?]

    IF(not [Allow Duplicates?], [My almost Unique field])

    So in your almost unique field, you do not mark that as Unique, but the formula field will be marked as Unique.   The one value that is allowed to be duplicated in a unique field is null,  so the above formula will be null if  [Allow Duplicates?] is checked.