How do I incorporate a Multi-Select Text field with a text field?

  • 1
  • 2
  • Question
  • Updated 3 years ago
  • Answered

I have two fields:

[Audience Primary] which is a Text-Multiple Choice field

[Audience Secondary] which is a Multi-Select text field

I am trying to create a third Formula-text field [Audience] but am having trouble with the formula.

This is what I need to do:

If [Audience Secondary] is blank, show the value in [Audience Primary] only.

If [Audience Secondary] is not blank, show the value in [Audience Primary] and the value in [Audience Secondary] separated by a comma.

So if  [Audience Secondary] = Partner; Service Provider

and [Audience Primary] = Customer

I want [Audience] to = Customer, Partner, Service Provider

If it is easier to use a semi colon in between each value, that's ok too

thank you in advance!

Photo of Karen

Karen

  • 222 Points 100 badge 2x thumb

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
Not tested but try this and lemme know.

List(";", [Audience Primary], ToText([Audience Secondary]))



It should end up being semi colon delimited which is way way easier, than comma delimited. 
Photo of Karen

Karen

  • 222 Points 100 badge 2x thumb
Thanks!! I had to add a space before and after the semi-colon to mimic the multi-select field format. Looks great:
Prospect/Customer ; Partner ; Employee
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
yes, you are quite right to do that! Thx for letting me know.  The List function is quite handy.