Discussions

Expand all | Collapse all

Convert 1 Column Report into a text string

  • 1.  Convert 1 Column Report into a text string

    Posted 22 days ago

    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
    ------------------------------


  • 2.  RE: Convert 1 Column Report into a text string

    Posted 22 days ago
    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
    ------------------------------



  • 3.  RE: Convert 1 Column Report into a text string

    Posted 21 days ago
    Thanks Mark! As usual, your advice worked perfectly!

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