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
------------------------------
Question
Convert Combined Text into a list?
This topic has been closed for replies.
+24To 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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.