Skip to main content
Question

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

  • April 12, 2018
  • 0 replies
  • 18 views
Forum|alt.badge.img+7
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]
      This topic has been closed for replies.

      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.
      Terms & ConditionsAccessibility statement