Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago

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

Can you tell me what field is being summarized?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

7 Replies

Sort By
  • JenniferSchafer's avatar
    JenniferSchafer
    Qrew Member
    5 years ago
    Program Name.

    I just realized that the document I uploaded had only 1 of the 3 screenshots so I attached a new doc with all 3.

    ------------------------------
    Jennifer Schafer
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      Can you post your formula for the field with the bullets?

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • JenniferSchafer's avatar
        JenniferSchafer
        Qrew Member
        5 years ago
        var text CombinedText = ToText([Active]);

        var text ConvertToVerticalListWithBullets=
        Trim(SearchAndReplace($CombinedText, " ; ","<br>&#8226")); // separate entries with a new line and a bullet

        If($ConvertToVerticalListWithBullets<>" ", "<br>&#8226") // this is a bullet for the first entry
        &
        $ConvertToVerticalListWithBullets

        ------------------------------
        Jennifer Schafer
        ------------------------------