Forum Discussion

PhelanSanders's avatar
PhelanSanders
Qrew Assistant Captain
7 years ago

make date time unique along with a text field

I would like to create a formula field that will concatenate a few text fields along with a date & time field.


My fields are;


Appointment Date, Provider Name, Case Manager

5 Replies

Sort By
  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    7 years ago
    Hi,

    Create the formula text field and try the below code.
    ToText([Appointment Date]) &"  "& [Provider Name] &"  "& [Case Manager]
    Thanks,
    Gaurav
    • GauravSharma3's avatar
      GauravSharma3
      Qrew Commander
      7 years ago
      Just to add, if your Case Manager field is a User field then, try UserToName formula.
      UserToName([Case Manager])
    • PhelanSanders's avatar
      PhelanSanders
      Qrew Assistant Captain
      7 years ago
      It says "This formula is incompatible with this field being marked unique
    • PhelanSanders's avatar
      PhelanSanders
      Qrew Assistant Captain
      7 years ago

      My date field was a Date & Time field. I changed it to just "date" and it works. I made a dedicated time field and included it into the formula. Thanks