Forum Discussion

ElandirayanJana's avatar
ElandirayanJana
Qrew Trainee
4 years ago

Multi select list to equivalent text in quickbase

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 displa...
Formulas and functions
Tables and fields
MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
4 years ago
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
------------------------------