Convert Combined Text into a list?
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? ------------------------------ ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTo 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
------------------------------
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
------------------------------
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
------------------------------
------------------------------
Paul Peterson
------------------------------
- MarkShnier__YouWhat 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
------------------------------- 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
------------------------------- MarkShnier__YouI'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
------------------------------