Forum Discussion
Yep, been there, done it, bought the T-Shirt (ie I had the same problem)
Just make a new checkbox field called [Allow Duplicate Serial?].
The make a new field called [Cannot use the same serial twice unless you flag as Allow duplicates].
The formula will be
IF(not [Allow Duplicate Serial?], [Serial Number])
The one "value", that is allowed to be duplicated when the field is flagged as unique is null. So the above formula would be null if [Allow Duplicate Serial?] is checked.
So flag this one as being unique and unflag the [Serial Number] as being Unique.
The reason for the long field name [Cannot use the same serial twice unless you flag as Allow duplicates] is to give the user a good error message when they try to save a duplicate which is not flagged to allow duplicates.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- GrantK2 years agoQrew Trainee
This should do the job - thanks Mark!
------------------------------
Grant K
------------------------------