Forum Discussion

Qrew Cadet

9 years ago

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

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 crit...

Forms

Formulas and functions

Tables and fields

QuickBaseCoachD

Qrew Captain

9 years ago

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"))