MichaelTamoush
4 years agoQrew Captain
Re: Multi select list to equivalent text in quickbase
I'm not sure if I understand correctly, but if you are looking for people to select from a multi select field but display as comma form then you would set your Multiselect Field Form Properties to 'Add or Edit' (so it is only visible in edit mode) and then make a formula field and set it to 'View Only'. The formula field would be formula text:
var text value = ToText([Your Multiselect Field]);
SearchandReplace($value, " ; ", ",")
All the search and replace does is switch the semi-colons to commas.
------------------------------
Michael Tamoush
------------------------------
var text value = ToText([Your Multiselect Field]);
SearchandReplace($value, " ; ", ",")
All the search and replace does is switch the semi-colons to commas.
------------------------------
Michael Tamoush
------------------------------