Forum Discussion

KarenHenke's avatar
KarenHenke
Qrew Cadet
5 years ago

Brain Teaser: Translating data from a multi-select text field to formula text field

Hello, I'm going to to my best to explain a super complicated situation :) I'm hoping one of you brilliant people can help me. There are values in Field A that I need translated (for lack of a bet...
Formulas and functions
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
np,  try this

var text MultiInTextFormat = ToText([[Field A]);

List(";",
IF(Contains($MultiInTextFormat, "Dog", "Poodle;Yorkie;Doberman"),
IF(Contains($MultiInTextFormat, "Cat", "Tabby;Siamese"),
IF(Contains($MultiInTextFormat, "Turtle", "Box"))



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • KarenHenke's avatar
    KarenHenke
    Qrew Cadet
    5 years ago
    Thank you Mark!
    When I try this formula, the first comma after "Dog" is highlighted with an error that says "Expecting )"

    Would love your thoughts on how to fix that.

    ------------------------------
    Karen Henke
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      Right, it was expecting more brackets

      fix fix this part here to add three missing  ),  one on each line 

      List(";",
      IF(Contains($MultiInTextFormat, "Dog"), "Poodle;Yorkie;Doberman"),
      IF(Contains($MultiInTextFormat, "Cat"), "Tabby;Siamese"),
      IF(Contains($MultiInTextFormat, "Turtle"), "Box"))




      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • KarenHenke's avatar
        KarenHenke
        Qrew Cadet
        5 years ago

        That worked perfectly!!! 

        I am literally in tears right now - this is such a relief!! I can't thank you enough!!



        ------------------------------
        Karen Henke
        ------------------------------