Forum Discussion

JohnnyDeVilla1's avatar
JohnnyDeVilla1
Qrew Trainee
5 years ago

Formula adding fields, but leaving one out if a certain word

I have a formula to name records in one of my tables that is something like: List(" - ",[Field1],[Field2],[Field3],[Field4],[Field5]) This works quite well for us, but when Field2 is selected as N...
Formulas and functions
JohnnyDeVilla1's avatar
JohnnyDeVilla1
Qrew Trainee
5 years ago
my solution was to pull from another field that has this formula and works well
List(", ",


IF(Contains(ToText([Field2]), "Hedge Hogs"), "Hedge Hogs"),
IF(Contains(ToText([Field2]), "Pink Ribbons"), "Pink Ribbons"),
IF(Contains(ToText([Field2]), "None"), ""))

------------------------------
Johnny DeVilla
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    I would have done this

    List(" - ",

    IF([Field1]<>"none",[Field 1]),
    IF([Field2]<>"none",[Field 2]),
    IF([Field3]<>"none",[Field 3]),
    IF([Field4]<>"none",[Field 4]),
    IF([Field5]<>"none",[Field 5]))

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JohnnyDeVilla1's avatar
      JohnnyDeVilla1
      Qrew Trainee
      5 years ago
      Thanks that works well!!

      ------------------------------
      Johnny DeVilla
      ------------------------------