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

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
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]
Photo of Steph Curry with the Base

Posted 7 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
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.