Forum Discussion

JenniferHall's avatar
JenniferHall
Qrew Member
2 years ago

Drop down filter vs user input filter

The filter for the District Name column is a drop down that the user can choose a selection from whereas the Division ID column the user types in what they are searching for. How would I go about changing the Division ID column to a drop down?

------------------------------
Jennifer Hall
------------------------------
Tables and fields

8 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    Is the Division ID a numeric or text field type?  I don't believe that numeric fields will offer up choices.

    A good line that I will attribute to Scott Burday @Scott Burday, Trinity  at Trinity I.S.,  is that where you have a field that you don't intend to do math on then it should be a text field and not a numeric field even though it only has numbers in it.   

    So you will have to consider the implications of changing that field to be a text field type. You may want to do this in a test copy of your application because if it gets used in other formulas or look up fields then you have to consider those applications.


    ​

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • JenniferHall's avatar
      JenniferHall
      Qrew Member
      2 years ago
      Both fields are text fields with the same settings.

      ------------------------------
      Jennifer Hall
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew #1 Challenger
        2 years ago
        Hmm, can you tell me how may unique choices there would be for that field?  There may be a limit if there are too many choices - not sure what "too many" is. Also is the field properties set to be "searchable"?

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