Discussions

 View Only
  • 1.  Segregating Info in Text Field Formula

    Posted 11-15-2022 11:40
    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
    ------------------------------


  • 2.  RE: Segregating Info in Text Field Formula

    Posted 11-15-2022 13:08
    //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
    ------------------------------



  • 3.  RE: Segregating Info in Text Field Formula

    Posted 11-15-2022 15:04
      |   view attached
    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
    ------------------------------



  • 4.  RE: Segregating Info in Text Field Formula

    Posted 11-15-2022 15:17
    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
    ------------------------------



  • 5.  RE: Segregating Info in Text Field Formula

    Posted 11-15-2022 15:24
    So sorry, I meant column.

    So column 1 would have all the Initiatives
    Column 2 would be how many have Site Plan Approval selected
    Column 3 would be how many have Rezone selected, etc.

    ------------------------------
    Sarah Driscoll
    ------------------------------



  • 6.  RE: Segregating Info in Text Field Formula

    Posted 11-15-2022 15:25
    Can you describe your relevant tables in their relationships?

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



  • 7.  RE: Segregating Info in Text Field Formula

    Posted 11-15-2022 15:34
    Of course!

    This is all pulling in from a connected table, so no table-to-table relationships. The summary report is summarizing Facility Name, grouping rows by Initiative Type and then grouping columns by Entitlement Type which is the multi-select field.

    The entitlement type field can have any of the following selected:
    None (ministerial approvals only)
    Site Plan Approval
    Special/Cond. Use Permit
    Rezone
    Variance
    PUD
    SEQUA
    Text Amendment
    SEQUA Negative Declaration
    SEQUA Environmental Impact Report

    We would want each column broken out to be one of the options above and then show the total count, unlike how it is currently breaking them out to show all the possible combinations. I was thinking this could be done with multiple formula fields, but was wondering if I could write one formula that would achieve the same look.

    ------------------------------
    Sarah Driscoll
    ------------------------------



  • 8.  RE: Segregating Info in Text Field Formula

    Posted 11-15-2022 15:39
    I think someone would have to work with you one on one to get this sorted out. Either QuickBase support if they are willing or if you have a small budget you can contact me directly by my email.  or hope there's someone else on the forum chimes in but it sounds complicated to solve on the forum with no access to the app.

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



  • 9.  RE: Segregating Info in Text Field Formula

    Posted 11-15-2022 15:39
    Understandable. Appreciate the support!

    ------------------------------
    Sarah Driscoll
    ------------------------------