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!

 

Forms
  • MarkShnier__You's avatar
    MarkShnier__You
    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. 

4 Replies

  • JoshuaDavis1's avatar
    JoshuaDavis1
    Qrew Cadet
    12 hours ago

    Mark,

    I have a follow up question for you. I've implemented the checkbox (Blank / TBD DPC) to allow duplicate entries. There are situations when our users do not know the DPC. So, we allowed duplicate records with a blank DPC. On our form, our checkbox (Blank / TBD DPC) is checked by default. The check goes away once an entry is made in the DPC field. How can I reenable the check after an entry is erased in the DPC field? I know users can click the checkbox. However, I prefer to create a form rule or formula. Thanks!

     

     

     

     

     

     

     

     

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