Text List Cannot Be Used In A Formula?
So, the new "text list" field type cannot be used in a formula?
Forum Discussion
Why not make a formula text field that parses the multi-select and returns the types minus the semi-colons.
BTW alot of my old formulas using ToText(multi-select field) have broken recently.
BTW alot of my old formulas using ToText(multi-select field) have broken recently.
- Because that negates the multi-select and I might as well use check boxes. A multi-select is a way to clean up the form from a buzillion check boxes. I have no interest in parsing and then having to maintain that parse. Maybe this would be a little less painful if they would allow array 0-19 instead so we don't have to target specific select options based upon name.
Anyhow Coach found the workaround until QB fixes the root.
