Add Value to Multi-select Text field

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

Hello, 

I have a Multi-select Text field [Suites]. I want to create a formula-text field based on [Suites] field. 

To each value in [Suites] field I want to add "dev" word and show it in separate field, [Dev Suites]. For example, if [Suites] contains "suite1;suite2", [Dev Suites] field should show "suite1dev;suite2dev".

Thank you in advance,

Nadia

Photo of Nadezda

Nadezda

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,218 Points 50k badge 2x thumb
not tested but try this

var text value = ToText([my multi select field]);



List("; ",

IF(Trim(Part($value,1,";"))<>"", Trim(Part($value,1,";")) & "dev",

IF(Trim(Part($value,2,";"))<>"", Trim(Part($value,2,";")) & "dev",


IF(Trim(Part($value,3,";"))<>"", Trim(Part($value,3,";")) & "dev",




etc

IF(Trim(Part($value,20,";"))<>"", Trim(Part($value,20,";")) & "dev")
Photo of Nadezda

Nadezda

  • 0 Points
Thank you! I've tested. Formula worked after my modification. It looks like this:
var text value = ToText([my multi select field]);
List("; ",
ToText(If(Trim(Part($value,1,";"))<>"", Trim(Part($value,1,";")) & "dev")),
ToText(If(Trim(Part($value,2,";"))<>"", Trim(Part($value,2,";")) & "dev")),
ToText(If(Trim(Part($value,3,";"))<>"", Trim(Part($value,3,";")) & "dev")),
ToText(If(Trim(Part($value,4,";"))<>"", Trim(Part($value,4,";")) & "dev")),
ToText(If(Trim(Part($value,5,";"))<>"", Trim(Part($value,5,";")) & "dev")))
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,218 Points 50k badge 2x thumb
thx for letting me know that its working.  I see that I had some extraneous text in my answer box that I have now deleted.