Discussions

Expand all | Collapse all

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

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

    Posted 04-11-2018 20:12
    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]


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

    Posted 04-11-2018 21:12
    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.