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