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.
Anyhow Coach found the workaround until QB fixes the root.