Forum Discussion

GunshamLakhiani's avatar
GunshamLakhiani
Qrew Cadet
5 years ago

Formula Field-Multi Select Text

Hi,

I have created a formula field which is of type multi select text. The formula is working fine but when i am selecting this field in the report selection as ask the user it shows as a plain text box and does not show as a multi select drop down to select the options.

Below is the formula which i have used in this field

Split(List(" ; ",
If( = true,"A"),
If (= false, "B"),
If ([ROption] = "A","Yes")
))

Can anyone help to find out why it does not display as a drop down?

Regards
Gunsham


------------------------------
Gunsham Lakhiani
------------------------------
Formulas and functions
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    A formula field cannot be used as a drop-down. Formulas - no matter the type - only produce an output as determined by the formula you've created.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • GunshamLakhiani's avatar
      GunshamLakhiani
      Qrew Cadet
      5 years ago
      Hi Blake,

      If that is the case then what will be use of this Multi Select Field and where and how it can be used?


      Regards
      Gunsham

      ------------------------------
      Gunsham Lakhiani
      ------------------------------
      • BlakeHarrison's avatar
        BlakeHarrison
        Qrew Captain
        5 years ago
        The Formula Multi-Select Text field is intended to allow you to combine multiple values from other data points so that they are presented to the user as a list of values. Formulas will only ever produce a value and cannot be used as a drop-down.

        https://help.quickbase.com/user-assistance/formula-multi-select-text.html

        The help topic linked above will give you additional information on this formula type.

        ------------------------------
        Blake Harrison
        bharrison@datablender.io
        DataBlender - Quick Base Solution Provider
        Atlanta GA
        404.800.1702 / http://datablender.io/
        ------------------------------