Custom deliminator for multiselect text field

  • 1
  • 1
  • Question
  • Updated 5 months ago
  • Answered
I have a multiselect text field that I need to use as a source for a system that requires a specific deliminator between strings. I need a way to change the semicolon that is normally returned between selections in a multiselect field with another character.

For example, a multiselect field with the following options selected

  •     Alpha
  •     Beta
  •     Gamma
  •     Delta

returns "Alpha;Beta;Gamma;Delta", but I need it to return "Alpha/Beta/Gamma/Delta".

As far as I can tell, there is no string substitution function in formula fields. I tried using the List() function, but it does not accept a multiselect field as a source. I have some variability in the options for the multiselect field, so doing something like the example below is not ideal:

List("/", If(Contains([Multiselect field], "Alpha"), "Alpha", ""),
          If(Contains([Multiselect field], "Beta"), "Beta", ""),
          If(Contains([Multiselect field], "Gamma"), "Gamma", ""),
          If(Contains([Multiselect field], "Delta"), "Delta", ""))
Ideally, I would like to directly replace semicolons with another character in the text field. Failing that, I would like to be able to format the multiselect field in such a way that the List() function will allow it as input.
Photo of Michael Herman

Michael Herman

  • 72 Points

Posted 5 months ago

  • 1
  • 1
Photo of Harrison Hersch (QB)

Harrison Hersch (QB), Quick Base Sr. Product Manager (Platform)

  • 1,540 Points 1k badge 2x thumb
Hi. We have a SearchandReplace() function coming in this release. Please see our February release notes for details.