Formula to turn a Combined Text Summary field into a vertical list

  • 2
  • 2
  • Question
  • Updated 5 months ago
  • Doesn't Need an Answer
Sometimes you may not want the "bubble" appearance of the native Combined Text Summary field on a report.  Here is a fun formula to change the appearance of a Combined Text Summary field into a vertical list.  

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

var text RemoveSpaceAfterSemiColon = SearchAndReplace($CombinedText, "; ",";");

// substitute new line for semicolon
SearchAndReplace($RemoveSpaceAfterSemiColon,";","\n")


Photo of QuickBaseCoach App Dev./Training (Mark Shnier)

Posted 5 months ago

  • 2
  • 2
Photo of Dan

Dan

  • 1,570 Points 1k badge 2x thumb
Nice. I haven't had a chance to try out the new formula functions yet, but they seem useful...