Forum Discussion

QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago

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 vertic...
App builders
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    Can you try one last thing and if that does not work I'm willing to have a quick look at your app on a GTM session.
    Can you add to the summary field filters where Program Name is not equal to blank?

    ------------------------------
    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
    Using your suggestion, I tried it a couple of ways. Still have the dots.

    ------------------------------
    Jennifer Schafer
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    Just to close the loop on this, I got in a GTM with Jennifer and immediately discovered that my post with the bullets formula had an extra space,  (now fixed in this thread way above)

    ------------------------------
    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
    I appreciate the assist and the super quick fix!

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