Forum Discussion

MICHAELSARGENT's avatar
MICHAELSARGENT
Qrew Cadet
4 years ago

Summary field to Formula Multi-Select Text field

Here's the setup: Application A has a semicolon delimited summary field called LOB Summary.  It can be any combination of up to 126 lines of business Application B has a multi-select field that ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
try this
Split(  // wrap in Split
List("; ", // change the separator to a semicolon
If(Contains(ToText([IntakeID - LOB Summary]),"All Sales and Distro"),"Retail/COR"),
If(Contains(ToText([IntakeID - LOB Summary]),"AT&T Retail"),"Retail/COR"),
If(Contains(ToText([IntakeID - LOB Summary]),"National Retail - Mobility"),"National Retail"),
If(Contains(ToText([IntakeID - LOB Summary]),"Authorized Retail"),"Authorized Retailer"),
If(Contains(ToText([IntakeID - LOB Summary]),"Online Call In"),"Online"),

etc
) // close the Split

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------