QuickBaseCoachD
7 years agoQrew Captain
Formula to turn a Combined Text Summary field into a vertical list
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")
var text CombinedText = ToText([My Text Concatenation Field]);
var text RemoveSpaceAfterSemiColon = SearchAndReplace($CombinedText, "; ",";");
// substitute new line for semicolon
SearchAndReplace($RemoveSpaceAfterSemiColon,";","\n")