JoshuaDavis1
7 days agoQrew Cadet
Allowing Duplicate Entries
Hi, What is the proper work around to allow duplicate entries with a field being marked as "Must Be Unique"? Thanks!
- 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.