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")
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
You can still group by that field on a report, I assume.