Forum Discussion

AndreonnaGarret's avatar
AndreonnaGarret
Qrew Assistant Captain
8 years ago

Is it possible make a field unique but conditional?

I have a field that is marked unique, but I have some records that don't have this field and need to behave a little differently. Is there any way to allow some entries in this field to be the same? F...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
No problem.
You can have duplicate entries as long as the duplicate is for the value blank.

So make a formula field called [Serial must be Unique] and mark it unique.

The formula will be like
IF(
Trim([Serial]="","",
Trim([Serial]="N/A",""
Trim([Serial] = "n/a","", [Serial])