Forum Discussion

ChrisNewsome's avatar
ChrisNewsome
Qrew Captain
7 years ago

Trying to connect tables to consolidate info on a report

OK so I have multiple tables... we call jobs "Opportunities" - these require a "Layout" and sometimes they result in a "Loose End". So each "Opportunity" can have multiple "Layouts" and "Loose Ends" ...
reports and charts
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
If that works but you do not like the bubble appearance, then there are a variety of formulas to turn that field into text and use any character is a separator.  For example, this one will turn it 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")
  • ChrisNewsome's avatar
    ChrisNewsome
    Qrew Captain
    7 years ago
    Would the bubble affect how it shows up in reports? I want to group by this field on a report.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    You can still group by that field on a report, I assume.