Skip to main content
Question

Segregating Info in Text Field Formula

  • November 15, 2022
  • 0 replies
  • 45 views
I currently have data pulling in from another source via a pipeline. In the original source, the field is a multi-select but when pulling in they are separated by a semicolon (ex: Variance;Special/Cond. Use Permit)

I am trying to figure out how to write a formula to convert this info from the text field into a multi select, allowing for teams to easily see all the different options selected.

------------------------------
Sarah Driscoll
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    //Field type Formula Multi Select Text

    Split([my semi delimited text field])

    That will allow dynamic filters for each unique choice


    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
      Terms & ConditionsAccessibility statement