Hi,
What is the proper work around to allow duplicate entries with a field being marked as "Must Be Unique"? Thanks!
Solved
Allowing Duplicate Entries
+4Best answer by MarkShnierYou
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.
+24An 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.
+4Mark,
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!
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.