Text List Cannot Be Used In A Formula?

  • 0
  • 1
  • Question
  • Updated 2 weeks ago
  • Answered

So, the new "text list" field type cannot be used in a formula?

Photo of JRogerson

JRogerson

  • 450 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
If you use

ToText([My Multi-Select field])

then it will be a text in a formula.
Photo of Wayne Major

Wayne Major

  • 298 Points 250 badge 2x thumb
I tried this, except i get an error basically stating that the ToText() function does not support conversions from a textlist (It basically says it is looking for text, numbers, bools, etc. but found textlist)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
The formula will save just fine. The formula editor has a bug in it which is giving a false warning.