Discussions

Expand all | Collapse all

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

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

    Posted 03-04-2020 15:40
    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 None I don't want None in the output. How would I write this so that when None it reads it as blank?

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


  • 2.  RE: Formula adding fields, but leaving one out if a certain word

    Posted 03-04-2020 16:22
    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
    ------------------------------



  • 3.  RE: Formula adding fields, but leaving one out if a certain word

    Posted 03-04-2020 18:09
    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
    ------------------------------



  • 4.  RE: Formula adding fields, but leaving one out if a certain word

    Posted 03-04-2020 18:27
    Thanks that works well!!

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