Drop down filter vs user input filter

Question

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
------------------------------

markshnier__you · Answer

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
------------------------------

markshnier__you · Answer

I did a test and the limit is 99 choices in the drop down list.&nbsp; If more than 99 choices, then you just get a data entry box.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

jenniferhall · Answer

Both fields are text fields with the same settings.------------------------------Jennifer Hall------------------------------

markshnier__you · Answer

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
------------------------------

jenniferhall · Answer

There are over 171,000 records so I am not sure how many possible choices there are for the Division ID and yes the field properties are set to searchable.------------------------------Jennifer Hall------------------------------

Forum Discussion

Drop down filter vs user input filter