Forum Discussion

JohnD's avatar
JohnD
Qrew Trainee
2 months ago

Converting delimited text into checkboxes

Greetings, I have downloaded a publicly available spreadsheet from the FDA containing their warning letters and have imported into quickbase.  It has worked well but I am stumped on how to do the fo...
  • MarkShnier__You's avatar
    2 months ago

     several ideas but let's take this step by step. If you create a new field of type Formula multi select text with this formula

    Split(List(";",
    [Cause 1], [cause 2], [Cause 3],   .... etc,  [Cause 9]))

    then you will be able to use that field as a dynamic filter. It would not do any fancy percentage calculations for you but if there are not too many different causes then you could quickly filter your master list down and write down on a piece of paper :) how many came up on the filtered report as you cycle through each Dynamic Filter option in turn.

    Do you have more ideas but why don't you start by doing that and post back. 

    Also can you tell me whether or not you have access to a master list of the causes, or do you need to generate them out of the data.