Discussions

Expand all | Collapse all

Create formula text if multi-select text field contains a selection

  • 1.  Create formula text if multi-select text field contains a selection

    Posted 01-05-2017 19:34
    I have a multi-select text field that I want to display the selections of that field in a different form field.  As it stands it doesn't display all of them, just the first one that satisfies the criteria.

    here's what I have written:

    If(Contains(ToText([Equipment:]), "TENS Unit, Back Brace")= true, "TENS Unit, LSO Back Brace",
    Contains(ToText([Equipment:]), "TENS Unit")= true, "TENS Unit",
    Contains(ToText([Equipment:]), "Knee Brace")= true, "Knee Brace",
    Contains(ToText([Equipment:]), "Secondary Knee Brace")= true, "Secondary Knee Brace",
    Contains(ToText([Equipment:]), "Back Brace")= true, "LSO Back Brace","")


  • 2.  RE: Create formula text if multi-select text field contains a selection

    Posted 01-05-2017 19:42
    try this

    List(", ",

    If(Contains(ToText([Equipment:]), "TENS Unit, Back Brace"), "TENS Unit, LSO Back Brace"),


    IF(Contains(ToText([Equipment:]), "TENS Unit"), "TENS Unit"),
    IF(Contains(ToText([Equipment:]), "Knee Brace"), "Knee Brace"),
    IF(Contains(ToText([Equipment:]), "Secondary Knee Brace"), "Secondary Knee Brace"),
    IF(Contains(ToText([Equipment:]), "Back Brace"), "LSO Back Brace"))


  • 3.  RE: Create formula text if multi-select text field contains a selection

    Posted 01-05-2017 19:44
    Mark, I don't know you but I think you've just become my best friend.  Thank you!


  • 4.  RE: Create formula text if multi-select text field contains a selection

    Posted 01-05-2017 19:45
    :)


  • 5.  RE: Create formula text if multi-select text field contains a selection

    Posted 07-12-2017 16:30
    Hey Mark, I just wanted to send a note to say that once again you came to my rescue (although you don't know it)  Working with a multi-text field, I was trying to apply it to a formula and then I found this example above, and BOOM, able to adapt it to my need and it works like a charm.  Jeff