Forum Discussion

GeorgeKhairalla's avatar
GeorgeKhairalla
Qrew Cadet
4 years ago

Convert a TextList field into richtext bulleted list

Hi, I'm not sure if there is an easy way to do this? I have a multi-select field that has 3 possible values: - Password Reset - Data Backup - Data Restore I'm working on presenting this in a ...
Formulas and functions
GeorgeKhairalla's avatar
GeorgeKhairalla
Qrew Cadet
4 years ago
Thanks for this Michael!
I wonder if there is a more straight forward way of doing it, hopefully someone will chime in.
Meanwhile, I'm going to give this method a try, I'm pretty sure it will work!

Thanks for sharing your cheat sheet! :)

------------------------------
George Khairallah
CTO
gotomyerp, LLC
------------------------------
MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
4 years ago
By the way, this is the rich text for a bullet in its most basic form.

"<span style='font-size:12px;'><li>First Bullet Text</li><li>Second Bullet Text</li></span>"


------------------------------
Michael Tamoush
------------------------------
  • GeorgeKhairalla's avatar
    GeorgeKhairalla
    Qrew Cadet
    4 years ago
    Just replying back to close the loop, to confirm that this solution works like a charm. A bit clunky, but it does the trick!

    Thanks again Michael!

    ------------------------------
    George Khairallah
    CTO
    gotomyerp, LLC
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago

      Try this as a more simple solution. Just insert your multi select field into the first line  


      var text CombinedText = ToText([My Text Concatenation Field for Child names]);

      var text ConvertToVerticalListWithBullets=
      Trim(SearchAndReplace($CombinedText, " ; ","<br>&#8226"));  // separate entries with a new line and a bullet

      If($ConvertToVerticalListWithBullets<>"", "&#8226") // this is a bullet for the first entry
      &
      $ConvertToVerticalListWithBullets



      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------