Forum Discussion

PhelanSanders's avatar
PhelanSanders
Qrew Assistant Captain
8 years ago

I have a unique field that is concatenated, however, I would still like blank values to save.

I have a unique field that has been concatenated. I want to keep this field unique, however, users should able to save records that do not require this field to be used. I do not want it to recognize ...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
There is one value that is allowed to be duplicated when setting a field to be unique and that is null.

So the formula would be like,

IF([Service Provided] = "HPP",
ToText([Appointment Date]) &"  "& [Related HPP Provider] &"  "& [Related HPP Case Manager]&"  "& [Appointment Time])

Note that the formula is silent as to what happens if the IF is not true, so the result will be nothing - ie null.