Skip to main content
Question

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

  • August 11, 2020
  • 0 replies
  • 20 views
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 better word) and put into Field B.
Field A is a multi-select text field. 

I need the formula in Field B to say (for example)

If "Dog" appears in the list in [field A] , then add "Poodle;Yorkie;Doberman" to [field B],
If "Cat" appears in the list in [field A], then add "Tabby;Siamese" to [field B],
If "Turtle" appears in the list in [field A], Then add "Box" to [field B],
otherwise leave the field blank
Separate the values with a semi-colon

I don't know if this would be an If formula, or a List formula, or Case formula??? SearchandReplace formula?
Thanks in advance for any thoughts!

------------------------------
Karen Henke
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement