Skip to main content
Question

Multi select list to equivalent text in quickbase

  • August 25, 2021
  • 0 replies
  • 38 views
Hi

 I have a multiselect text field which have 50 to 100 options. User might select upto 4 in the field.

For Example, User might select eyes, nose, teeth, ear, using the formula i need to display appropriate attributes as below.

User selection:  eyes, nose, teeth, ear
I need to display : vision, smelling, white, hearing

User selection is the multi-select text and we need to display the text using formula. Any leads/support is appreciated.

Thanks in advance.

------------------------------
Elandirayan Janarthanan
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+14
    A formula field with: ToText([Your Multiselect Field]) will output:

    Choice A; Choice B; Choice C

    If you want a comma or something else:

    var text value = ToText([Your Multiselect Field]);

    SearchandReplace($value, " ; ", ",")

    Whatever you put in the final quotes will replace all the semi-colons.

    ------------------------------
    Michael Tamoush
    ------------------------------
      Terms & ConditionsAccessibility statement