Skip to main content
Question

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

  • February 24, 2019
  • 0 replies
  • 448 views
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")


    • DanLadner1
    • Registered
    • February 25, 2019
    Nice. I haven't had a chance to try out the new formula functions yet, but they seem useful...
    Thank you for sharing this. I am trying to do something similar, but can't seem to figure out where to insert your formula. I have a combined text list that I am pulling from a child table as a consolidated list in the parent table through the table relationship. When referencing this combined text field as a column in a report, it renders as a continuous list, with each item surrounded by a bubble. I want to:

    - Render the text as a vertical stack
    - Remove the bubbles
    - Render a bullet in front of each line item

    Do I insert your formula into the formula section at the report level, and is it possible to modify the formula to add bullets and remove the bubbles? Thank you!

    Terms & ConditionsAccessibility statement