Convert 1 Column Report into a text string

Question

Hello!
On my form, I have an embedded report that has only one column. I'd like to create a formula field that takes the values in the report and converts it into a text string separated by a semi-colon.Example - the table column lists:Product AProduct CProduct XI would like the new field to display: Product A; Product C; Product XIs this possible? Thank you in advance!------------------------------Karen Henke------------------------------

MarkShnierYou · Answer

On the Relationship where 1 parent has many children you can make a combined text summary field of the children for that field. Then that will appear as a bubble-like appearance.

You can convert that to text with ToText([my combined text summary field]) field which is a formula text field type.

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

Sign up

Login to the community