Forum Discussion

KarenHenke's avatar
KarenHenke
Qrew Cadet
5 years ago

Convert 1 Column Report into a text string

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 A
Product C
Product X

I would like the new field to display: Product A; Product C; Product X

Is this possible? Thank you in advance!



------------------------------
Karen Henke
------------------------------
  • 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
    ------------------------------
    • KarenHenke's avatar
      KarenHenke
      Qrew Cadet
      Thanks Mark! As usual, your advice worked perfectly!

      ------------------------------
      Karen Henke
      ------------------------------