Skip to main content
Question

Changing a text string into the multi select bubble format?

  • April 6, 2020
  • 0 replies
  • 26 views
MarkShnierYou
Forum|alt.badge.img+22
Does anyone know how to change a string or multiple words which is the result of a formula into the appearance of a Multi select field with that pill/bubble format?  I can control the delimiter between the words



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach

Forum|alt.badge.img+5
  • OanaWhalen
  • Registered
  • April 7, 2020
Mark,

The native Split function (a relatively new creation, I believe) will convert a text string into the multi-select bubbles. Here is the support info for the function:
https://login.quickbase.com/db/6ewwzuuj?a=q&qid=6#dynamic/{%22sidebar%22:[],%22searchString%22:%22split%22,%22ver%22:1}

The function can be used with or without defining a delimiter, the default is a semicolon unless otherwise specified. If you end up with strange blank bubbles in your result due to one of the words in your formula being blank in some instances, let me know as I've figured out a workaround.

------------------------------
Oana Toma
------------------------------
Terms & ConditionsAccessibility statement