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 ...
Forum Discussion
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
------------------------------
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
------------------------------
- Both fields are text fields with the same settings.
------------------------------
Jennifer Hall
------------------------------- 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
------------------------------- 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
------------------------------
