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

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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

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

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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

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

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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Convert Combined Text into a list?

23 Replies

MarkShnier__You
Qrew Legend
5 years 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
[email protected]
------------------------------
- PaulPeterson1
  Qrew Assistant Captain
  5 years 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
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years 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
    [email protected]
    ------------------------------

Forum Discussion

Convert Combined Text into a list?

23 Replies

Related Content

Combining Multiple Text Lists into One Text list Field

Convert combined text email list to list user field

Converting delimited text into checkboxes

Error listing for Pipelines?

Sorting Combined Text Field by Record ID#