Forum Discussion

AnnettaColeman's avatar
AnnettaColeman
Qrew Cadet
3 years ago

Populating a Formula Multi-Text Field from Summary Fields

Use Case:    I have a "Project" Parent Table with an associated "Intake Worklists" Child Table. The child table is populated with n number of Product Team Records (currently 7 Product Teams) via ...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago

Try this as a formula multi select field type.  It will behave nicely when used as a Dynamic Filter. 

Split(ToText([my combined text summary field])



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
AnnettaColeman's avatar
AnnettaColeman
Qrew Cadet
3 years ago

Hi Mark -
Thanks!  Works nicely.  Our version of this ended up as follows:

Split(List(" ; ",
If([# Impacted? (BH)]>0,"Behavioral Health"),
If([# Impacted? (Claims)]>0,"Claims"),
If([# Impacted? (Clinical)]>0,"Clinical"),
If([# Impacted? (Member)]>0,"Member"),
If([# Impacted? (Pharmacy)]>0,"Pharmacy"),
If([# Impacted? (Provider)]>0,"Provider"),
If([# Impacted?  (Reporting)]>0,"Reporting")))



------------------------------
Annetta Coleman
------------------------------