Discussions

Expand all | Collapse all

Convert Combined Text into a list?

  • 1.  Convert Combined Text into a list?

    Posted 28 days ago
    What is the best way to convert a combined text summary field to a list?  Also, is it possible to find the highest value, lowest value and total items in the field?

    ------------------------------
    Paul Peterson
    ------------------------------


  • 2.  RE: Convert Combined Text into a list?

    Posted 28 days ago
    To convert a combined text summary field into a vertical list, you can use this syntax in a formula text field.

    SearchAndReplace([My Combined Text Summary field], " ; ", "\n")

    The best way to get the min max and count would be to make new summary fields on the same relationships where the Combined Text Summary field was made.

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



  • 3.  RE: Convert Combined Text into a list?

    Posted 21 days ago
    This method doesn't actually generate a list.  Is there any way that will create an actual list rather than something that looks like one?

    ------------------------------
    Paul Peterson
    ------------------------------



  • 4.  RE: Convert Combined Text into a list?

    Posted 21 days ago
    What do you mean by "an actual list".  Can you attach an image of what you want it to look like?

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



  • 5.  RE: Convert Combined Text into a list?

    Posted 21 days ago
    It's not a matter of what I want it to look like, it's more a matter of how I can manipulate the data.  I need to get a count of the actual items in the "list", get max and min values over that same list.  I am able to extract some of the data into a summary field, but not for all fields needed.

    ------------------------------
    Paul Peterson
    ------------------------------



  • 6.  RE: Convert Combined Text into a list?

    Posted 21 days ago
    I'm still not understanding. 
    I previously posted this above.

    The best way to get the min max and count would be to make new summary fields on the same relationships where the Combined Text Summary field was made.

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



  • 7.  RE: Convert Combined Text into a list?

    Posted 18 days ago
    I had issues getting the summary fields right.  I think I'm finally there.

    ------------------------------
    Paul Peterson
    ------------------------------