Forum Discussion

PhelanSanders's avatar
PhelanSanders
Qrew Assistant Captain
7 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 blank values as duplicates.

MY unique field is below, and the condition field is titled "Service Provided" is = to "HPP"


ToText([Appointment Date]) &"  "& [Related HPP Provider] &"  "& [Related HPP Case Manager]&"  "& [Appointment Time]
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 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.