Forum Discussion

SarahDriscoll1's avatar
SarahDriscoll1
Qrew Trainee
3 years ago

Segregating Info in Text Field Formula

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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    //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
    ------------------------------
    • SarahDriscoll1's avatar
      SarahDriscoll1
      Qrew Trainee
      3 years ago
      That worked perfectly!

      Another question. We would want to see how many sites might have Site Plan Approved as an option and then have another row show many might have Rezone selected. Is there a way to do this with one formula instead of multiple? Would it be a report formula?

      ------------------------------
      Sarah Driscoll
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        3 years ago
        sorry I'm not understanding this

        and then have another row show many might have Rezone selected.

        Did you mean another column?

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------