Discussions

Expand all | Collapse all

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

  • 1.  Formula to turn a Combined Text Summary field into a vertical list

    Posted 02-24-2019 17:22
    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")




  • 2.  RE: Formula to turn a Combined Text Summary field into a vertical list

    Posted 02-25-2019 12:54
    Nice. I haven't had a chance to try out the new formula functions yet, but they seem useful...


  • 3.  RE: Formula to turn a Combined Text Summary field into a vertical list

    Posted 12-20-2019 08:58
    Edited by Michael Zeppieri 12-20-2019 09:00
    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!




  • 4.  RE: Formula to turn a Combined Text Summary field into a vertical list

    Posted 12-20-2019 09:23
    This would be a new text Rich Text formula field.  

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

    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)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------