Forum Discussion
JonathanHeuer
Qrew Cadet
Thanks Mark, I like this approach. The problem is that the length of the array in the summary text field is arbitrarily long; that is, it may well have more than 26 elements in it.
------------------------------
Jonathan Heuer
------------------------------
------------------------------
Jonathan Heuer
------------------------------
MarkShnier__You
4 years agoQrew Legend
Well there is no limit to the length of a formula
var text AA = Trim(Part($value,27,";"));
var text AB =Trim(Part($value,28,";"));
var text AC = Trim(Part($value,29,";"));
etc.
just make the formula longer, for the largest number of practical elements, say 100? Whatever, it's just copy and paste to make the formula longer.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text AA = Trim(Part($value,27,";"));
var text AB =Trim(Part($value,28,";"));
var text AC = Trim(Part($value,29,";"));
etc.
just make the formula longer, for the largest number of practical elements, say 100? Whatever, it's just copy and paste to make the formula longer.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------