Forum Discussion

GeorgeKhairalla

Qrew Cadet

Re: Convert a TextList field into richtext bulleted list

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
------------------------------

3 Replies

MarkShnier__You
Qrew 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
------------------------------
- GeorgeK
  Qrew Member
  4 years ago
  
  Ah .. thanks Mark!! That was the original idea I was trying to accomplish based on a similar thread where you presented this type of method.
  
  Thanks!
  
  George Khairallah
  CTO at gotomyerp
  P  877-888-5525
  E  george.k@gotomyerp.com
  W  http://gotomyerp.com
  - MichaelTamoush
    Qrew Captain
    4 years ago
    Awesome Mark!
    
    I'm adding this simpler solution to my notes.
    
    Thanks!
    
    ------------------------------
    Michael Tamoush
    ------------------------------